I'm new to Airtable with some background in relational databases but I need advice.
I have built base for our nonprofit to manage volunteers. The Volunteer table has names, skills, availability, etc and the Personal References table holds several references for each volunteer. The 2 tables are linked with a Volunteer ID field - one-to-many relationship (volunteer-to-references) Typically, I would like potential volunteers to submit their applications via a form on our website.
I have tried using 3rd party tools to build forms to add records to these tables but these tools only allow using one table per form. Is there another way to collect this information, populate both tables, and maintain the links? Either within Airtable or elsewhere?
Thanks!
