Unique Client ID despite duplicate records
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?