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

Discussion created by bobg on Feb 13, 2013
Latest reply on Feb 13, 2013 by bobg

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.