I think this is a medium-easy task. I need three-four tables, that are interconnected for coordinating an event. The time table is short - next week or so. The budget is shorter - we are an all volunteer new organization.
No data to worry about - just need to get the framework set up to put it into. I can make the various fields, but where I need help is with the linking.
The main list is a list of exhibitors. Some are also on Tab 2 as speakers. Simple, right? Where I need help is in making it so if someone is added as a Speaker, they automatically get added to the Exhibitor list. Then I need to have a 3rd Tab - Sponsors, who also automatically get added to the Exhibitor list. There is a 4th Tab - one for the company. It would track the role and year, based on the above entered data. Example: At a glance can see that Acme participate in 2016 (Presenter, Exhibitor), 2017 (Exhibitor, Speaker)
I need to have some way to repeat this in upcoming years - maintaining the old data, but starting over fresh each year.
I think I could figure it out if I have to, but my bandwidth is all focused on revising the website, in addition to my day job.