AnsweredAssumed Answered

Unique Client ID despite duplicate records

Question asked by HankCieplinski on Oct 14, 2010
Latest reply on Oct 14, 2010 by philmodjunk

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?

Outcomes