are you gathering the client birth date in a field, too ?
you should not include fields holding data subject to change in time in an attempt of identifying unique.
Birthdate never changes, address can change - John Jones at 1, Main Street can move out and another John Jones can come at his place.
and sh*t happens, anyway.
Hi - We don't record client data to that depth. Nearest we get is phone number address or next of kin. Is there a script I could use to prevent this?
on new client creation, gather client data in globals, in a popover with an OK button.
on OK button click, do a ExecuteSQL on your DB with First name, Surname and PhoneNumberClean*, if valueCount of the SQL result is not 0 then beep and exit script (false).
* PhoneNumberClean = Filter(PhoneNumber; "0123456789"), to be defined in the table.