prevent duplicate records - combined key
I have a bridge table between two entity tables; a many-to-many relationship. For example, Beers, Distributers, Beer_Distributers. I want to prevent duplicate entries in the Beer_Distributers table...
Forum Discussion
No problem
Make a text formula field with the formula
List("-",totext(Beer_id]),totext([Distributer_id])
.. and turn on the Unique checkbox for that field.
call the field something like [Same BeerID - same Distributor ID] so that you error message is meaningful to the end user of your app. Try entering a duplicate, observe the red error message and edit your field name to make the error message instructive to the user.
Make a text formula field with the formula
List("-",totext(Beer_id]),totext([Distributer_id])
.. and turn on the Unique checkbox for that field.
call the field something like [Same BeerID - same Distributor ID] so that you error message is meaningful to the end user of your app. Try entering a duplicate, observe the red error message and edit your field name to make the error message instructive to the user.