I’ve spent weeks trying to understand how to properly manage linked record fields in my base, and I’m still stuck. No thanks to ChatGPT - total waste of time. I should have come here a lot earlier. Here’s what I’m struggling with: I have one main Entities table that contains artists, labels, distributors, producers, etc. In other tables (like Songs and Releases), I need to link to Entities in multiple ways (for example: Artist, Featured Artist, Label, Distributor, Producer). Every time I create a separate link field for each role (e.g., “Artist Name,” “Label”), Airtable automatically creates a new reciprocal field in Entities, which results in multiple “Songs” or “Releases” columns there. This clutters the Entities table and makes it impossible to keep clean. When I delete these extra reciprocal fields in Entities, it turns my original link fields in Songs or Releases into single line t
