1 Reply Latest reply on Nov 2, 2010 10:08 AM by philmodjunk

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

    jayankurian

      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