How can I combine all of the tables into one 'Master' type of table so that I can run queries across table fields?
I understand that there are lookup fields. But each Volunteer Event has multiple Volunteers. Each Volunteer can have multiple skills. So if I want to run a query where I want to find out the pool of skills that the pool of volunteers bring to Volunteer Events between Sept 2023 and Octo 2023. How would I construct the Master table (or some other method) to run such a query?