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
Build a formula-text field concatenating the [Related Beer] & "-' & [Related Distributor] and then make that field Unique.