Create or define a field as unique which is a combination of 3 concatinated fields
I need to create a unique field which is a combination of 3 fields together.
Existing fields and the data
Unique field(which is the combination of TK ID+Last Name+Tour)
How do I create the above "ID COMB" as a unique field?
The reason why I need this?
To avoid duplicate record entry of Last Name:Smith with TK ID of 2345 and Tour II.
I hope my above explanation is clear.
Any help really really appreciate.
Thank you PhilMod.............
I tried PhilMod's suggestion already.
The issue is that the calculated field(unique field created as text field/auto enter option) becomes unique as soon as I enter the "Last Name" and this field displays only the first field value, which is the "Last Name".
Any other suggestion...... Anybody.
Define your calculation as an auto-entered calculation on a text field. You can then specify unique values on the validation tab and you will have what you specify.