Greetings! Newbie here, I think the best way to ask this question is to just explain what I’m trying to do.
We produce comedy shows, and are trying to create a table that will contain all the pertinent info for each show. Here’s how it’s set up:
- One table, called TALENT, contains records for each performer, with the typical vitals (name, phone, headshot, social media, etc.)
- One table, called VENUES, contains all the same kind of typical vitals, but for the physical locations.
- One table, called SHOWS, aggregates one linked record from VENUES, and multiple linked records for every performer we’re using from TALENT, along with other show specific fields such as date and time, etc.
Here’s the problem:
For each performer’s linked record, we want to append a few fields, like CUT RATE (currency), FLAT RATE (currency), and POSITION (example: opener, featured, headliner). These vary from show to show, and we may have the same performer on two show records simultaneously getting paid different rates, so these fields can’t live within the TALENT table, they have to live within SHOWS, but they need to reference an individual record from what is a list of linked records.
Any idea how to do this? Thanks in advance!