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
I'm guessing that you are using a lookup field in your formula.
You may not make a lookup field part of the formula. for example instead of using [Customer Name] in the formula (which is a lookup field), use [Related Customer] which is not a lookup field.
If that is not the problem I suggest that you post a new question and explain what field types you are using in your formula.
You may not make a lookup field part of the formula. for example instead of using [Customer Name] in the formula (which is a lookup field), use [Related Customer] which is not a lookup field.
If that is not the problem I suggest that you post a new question and explain what field types you are using in your formula.