I followed the YouTube video to create a dereference table to link two databases and create a drop-down entry list. Everything works as expected. How can I stop my form from allowing the same data to be entered more than once? I want to avoid duplicate rows in my main table. Can I use a Valid_If
expression. I have tried
the expression =NOT(IN([_THIS],Table1[FirstLastName])).
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |