The app is to help run sessions, where each session has a number of members attending, each member with a specific role/duty.
For this, I have a “Session” table which will holds set of dates for each session held or scheduled.
The set of possible roles that members would perform are defined in a “Role” table.
The technical problem is figuring out how to populate a third table “SessionRoles” automatically when a new Session is scheduled i.e. record is created. SessionRoles is roughly a union of the two tables with key fields SessionDate and Role, each field coming from the two tables.
What I would like is when adminstrator creates a new Session record, system has to automatically create new records in SessionRoles for that new Session date. In the example above, if a session record for 03/15/2019 is created, I would like to have SessionRole to have 2 new records created, one for each role in the Role table