AnsweredAssumed Answered

Create or define a field as unique which is a combination of 3 concatinated fields

Question asked by jayankurian on Nov 1, 2010
Latest reply on Nov 2, 2010 by philmodjunk

Summary

Create or define a field as unique which is a combination of 3 concatinated fields

Product

FileMaker Pro

Version

11

Operating system version

Wndows

Description of the issue

I need to create a unique field which is a combination of 3 fields together.

Example:
Existing fields and the data
TK ID:2345
Last Name:smith
Tour:II

Unique field(which is the combination of TK ID+Last Name+Tour)
ID COMB:2345smithII


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.

Output.jpg

Outcomes