table relationship help.
I have chosen to restructure my BD to make it more flexible. It is an event productions management system. Schedules used to be related to one equipment list on one date but that is not representative of how we work.
Now schedules are related to an "event date" record (dates that needs asset)
I need a way to assign many equipment lists to a schedule. I have a checkbox set with a list of EQ list names that I can check but it lists the EQ list ID numbers and I cannot seem to create a solid table relationship that will relate to all line items in the checked EQ lists.
Is there a way to make this work or a better way all together?