2 Replies Latest reply on Feb 13, 2013 5:27 PM by bobg

    Newbee here... How to prevent creating duplicate records?


      I have two tables People and Events linked by table Participants. When adding a person to an event, how do I prevent adding another (duplicate) record if that person is already linked to the event? Right now it is the simplest script.. create new record, set fields, commit. I'm thinking that it should first check (find?) and put up a dialog (record already exists) or add the record if current one is not found? Not sure how to do that.