6 Replies Latest reply on Apr 29, 2017 4:28 PM by philmodjunk

    Creating New Records


      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.


      Thank you:


      Rommel Hernandez