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
Events
,Partners
andUsers
- Each
User
is associated with onePartner
- Each
Event
allows eachPartner
a certain number of places (guestAllocation
) - Each
User
must be able to log in via the front end and update the names of the people who are going to the event (limited byguestAllocation
) associated with theirPartner
.
Structure:
- Currently, SuperTable lists the
Partners
invited to that event and their allowedguestAllocation
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
Event
? - 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?