I have an interesting problem that I would love your input on.
What you’re looking at here is a database for a comedy club. The idea behind this specific database is to look into the different events done and to be done.
A part of the fields is the date, location, show type, role of artist, and artist.
Each event (with specific date) has multiple artists with different roles, I am currently adding multiple records per event in order to separate the artists roles and get a count of each artist’s role in each show type through a related database as seen below
Is there a way to add 1 record per event and add as many artists to this specific event while picking a role for each artist which would then give me an accurate count?
The only way that you can do this is to restructure your database as a “many-to-many relationship”, which is a more complicated type of relationship that requires 3 tables (instead of 2 tables) for your record linking..
You can read more about many-to-many relationships in Airtable’s support document here.