I have a table called Events and in it is a record called Monopoly Tournament
I have a table called Users and in it is a bunch of people that come to events
I have a table called Registrants and in it is a field for 2 things … 1) single linked event 2) single linked user (thus, there are multiple records for users who are coming to the Monopoly Tournament)
I have lots of registrants already coming and they want to have the same event the next week.
Is there a way to …
- Easily duplicate the “Monopoly Tournament” record in the Event Table
- Automatically duplicate the registrants for the original event but change the event field value to the newly created event