Hi there Antonia!
What I would recommend doing here is getting rid of any tables that are duplicates of your “people” table to eliminate confusion
and then changing all of your linked fields (Author(s)/Director(s)/Cast/Crew) so that they are all linked to the same table, “People”
If you have 4 linked fields in your “productions” table that all link to “people”, your “people” table will have 4 equivalent linked fields that should behave exactly as you’re describing.
Airtable will NOT automatically correctly name these, so I recommend doing these one at a time.
What I mean by this:
Step 1: Edit the “Authors” field on your “productions” table so it links to the “People” table, instead of the “Authors” table
Step 2: Delete the “Authors” table since it will not stay up to date and you no longer need it
Step 3: Hop on over to the “People” tab, and identify which linked field you just created. The name of the linked field will be something like “Productions” or “Productions 2”. Rename it to “Author”. This field will now show all of the productions each person is “author”.
Remember: this works both ways, so you can add productions to people via the people table, or add people to productions via the productions table
You can also use this field as a filter, ex: if you want a list of ONLY your authors, filter your list so it only shows you People where “Author” is not empty.
