Hello FM community:
I'm fairly new with FMP and am confronted with this situation:
User enters new contact information. If the concatenated field (first & last name if person, company name if company) is NOT unique then user is notified that the contact already exits.
User is then prompted to revert changes.
However, a new blank record with a new ID is still added. I would like to prevent this from happening so that a new record with a new ID is not added until the validation test passes.