I followed the YouTube video to create a dere...

G_Man
New Member

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])).

0 2 336
2 REPLIES 2
Top Labels in this Space