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 |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |