I have a set of databases to manage season tickets. The main databases:
1) Partners
2) Games
3) Tickets
I have multiple seat locations per game. For discussion say there are
Section 1 row 2 seats 3,4,5,6
Section 2 row 4 seats 7,8
Right now the tickets database has 1 record per ticket, so in the example 6 records per game. Each ticket has an owner field which is a DB relationship to the partners database. Assume all seats for a particular location for a particular game are assigned to the same partner, so if you have game #7 in Section 1 you have seats 3,4,5,6.
Right now, I have to update each individual ticket record with the owner. I would like to be able to update one record with the owner and have the owner field in the other three records update. Is there a way to do that?
I had thought of creating a location database so the hierarchy is
Games
Locations
Tickets
Using the example above, the location database would have a record for section 1 and one for section 2 for each game.
but I'm hoping there is a way to link groups of records together with my existing structure.