The problem is how to assign one or more people to one or more stops in an itinerary. My question to the community: is the following design feasible and, if so, a pointer to a similar example would be wonderful. I'm having trouble working out how to best implement the two parts – Itinerary and Persons – on the layout.
File one: list of trips
File two: list of stops on a trip – its itinerary
File three: people who may be selected to join one or more of the itinerary's stops.
I have this idea – which may or may not be feasible – of a layout which has two parts; (1) a part which lists a trip's itinerary [File two] and (2) a part which lists people [File three]. A button on the layout would execute a script which would create a record in a join-table for each stop-person record pair. There would also be an “undo” option somewhere in the process.
The two parts would have a checkbox next to each record which the user can use to select (1) which stops in the itinerary that the (2) person(s) selected are to be assigned. [If there may be better methods for selecting multiple records for a file, please let me know.] Here's a rough sketch of what I'm thinking of:
Thank you very much for your advice.