How to setup 'Master' table to run query across multiple table data?

[donut89]

Hello,

Referring to this Volunteer Management template:

Volunteer Management Template - Free to Use | Airtable

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?

[Arthur_Tutt]

Hey @donut89 Great question! Here's a quick Loom Video to demonstrate how I'd go about setting up and linking the tables, and how I'd make a 'master' table to quarry the data. 

Table Structure:

 

 Let me know if that makes sense!