6 Replies Latest reply on Oct 14, 2010 12:17 PM by philmodjunk

    Unique Client ID despite duplicate records

    HankCieplinski

      Title

      Unique Client ID despite duplicate records

      Post

      Sorry - new on FMP as of yesterday. 

      Can anyone tell me how to create a unique id even though I will have duplicates records? 

      I need the client id to remain constant when a client has a new record because of an additional service, if that makes any sense.

      I used the Auto serial number increment by 1 thingy, but when I create a new record with the same last/first name etc, the client id increments.

      How do I create a relationship between the client id field and the last/first/and birthdate fields so this can be avoided?