Hi all, I’ve been using Airtable as an employee for the last few months but only recently have started building some tables on my own, and I’m running into a hurdle that I think either has an incredibly simple answer or just requires a different approach. After going through forums for hours, I figured posting might be the quickest way to find a solution.
This will be a musician related database, and I have two tables - ‘Owners/Writers’ to keep records of artists:
And ‘Songs’ to house the information for each song they might be a part of:
As you can see, each song may have multiple writers. I want to create a column in the ‘Owners/Writers’ table that shows every song that each writer may be a part of; for instance, Ben Allen is a writer on both of the example songs, Song 1 and Song 2, and I’d like those records to be displayed in the ‘Owners/Writers’ table.
The problem is when I create a linked record in the ‘Owners/Writers’ table to the ‘Songs’ table, it doesn’t automatically populate - which is my ultimate goal here. It creates the ability to select the songs manually, but I need that info to autopopulate if I enter a writer on any song. So in that scenario, as I add new songs to my table (often with the same writer involved), it will show up, linked, in one column in the ‘Owners/Writers’ table.
Am I missing something incredibly basic here? I’ve played around with rollup/lookup fields and have been able to get the names of the songs to all display in one text-only field, but I really need those to be linked to actual records.
Any advice would be very appreciated!