I am trying to make a warning note for a portal populated with registrant names for an event. The warning should show when the same participant is entered in the same event. The portal is in the event file, and links via a many to many join file to a registrant file.

How can I set up a script so that a warning notice shows up whenever a registrant is duplicated for the same event? Registrants have unique IDs, and so do Events.

I'm thinking of searching for duplicate "reg ID + event ID" in the join file, but am unsure how to launch such a search from the event file registrant portal.

Thanks in advance.

Kirsten Masse

You can make a concatenated key field (regID & " - " & eventID) and make a self-join relationship based on that key. If you loop through each record and test for Count(any field through that relationship) you can find all those with a count > 1; your duplicates.