I'm creating an app to schedule people into numbered Time Slots(Each person can be scheduled in many time slots; also, each time slot can include many people).
We just figured out how to structure the table to link them using an intermediate table: People->Events->Time Slots.
Now I would like to create a form to schedule these people. The top of the form would have a name; the subform would have a list of all the time slots with a check box next to each one. I'm not sure how to make this check box connect with the intermediate table and create a record.
Thanks in advance (and have a great weekend),
Dan
We just figured out how to structure the table to link them using an intermediate table: People->Events->Time Slots.
Now I would like to create a form to schedule these people. The top of the form would have a name; the subform would have a list of all the time slots with a check box next to each one. I'm not sure how to make this check box connect with the intermediate table and create a record.
Thanks in advance (and have a great weekend),
Dan