I'm trying to work out the best way to administer this. The point of the system I'm building is as follows:
- A front-end system which contains
Useris associated with one
Partnera certain number of places (
Usermust be able to log in via the front end and update the names of the people who are going to the event (limited by
guestAllocation) associated with their
- Currently, SuperTable lists the
Partnersinvited to that event and their allowed
At the end of all this I need to export a Guest List which should be generated by the names of people who are attending the Event (if there are missing names and spare guestAllocation, there will be default value).
- What's the best way to structure this in the database? Should I have one Event that gets updated by multiple users somewhow, or an Entry for each Partner related to an
- Is it possible to update a single Entry by multiple Users who can only add the correct number of names to the guest list for their Partner?