If the ID is automatically generated by FileMaker by auto entering a serial value ( which is the normal procedure ), than you do not have any reason to worry.
Hi thank you for your reply
Unfortunately, the ID is entered manually
Why is the ID entered manually? The unique values check cannot be done until the record is committed--which is what happens when you click outside the field. An OnObjectExit trigger can perform a script that commits the record.
And from a database design point of view, the Client_ID really should be either an auto-entered serial number or Get ( UUID ) text string.
The company has a DB, where we only have restricted access, so we're building our own DB, as a kind of archive. So we get the Client_ID from the company...
I've tried committed when leaving client_ID, or entering another field... but no success.... don't get it why