I currently have a join table and I need to be able to prevent multiple occurrences of the same information in the join table. Lets say I have;
In my join table I only want there to be one occurrence of a color and a shape i.e, Red Circle, Red Triangle, Orange Circle, etc.
ID Table A ID Table B ID
1 1 1
2 1 3
3 2 1
The only way I can think of preventing duplicates is to create a calculated field to concatenate Table A ID and Table B ID and in my validation have that set to unique values only.
ID Table A ID Table B ID ComboID
1 1 1 11
2 1 3 31
3 2 1 21
Is this an acceptable method? Is there a better or "right" way of doing this?