I'm having a problem in trying to create/understand parent/child fields and linked databases. Here is what I am trying to do:
Setting up databases to track tickets in a season ticket group.
Three primary databases:
1) Partners - list of partners/customers
Key field is PartnerName
2) Games - list of games for which I have tickets
Has GameNumber field (Integer)
3) Tickets - list of tickets by section/row/seat (multiple per game)
Has GameNumber field, want to link to same field in Games
Has Owner field, want to link to partners
Thinking that Tickets can be a child database to both Games and Partners.
I want to be able to update the Owner field in Tickets so that if I select a partner in the Partners SB I can see all tickets assigned.
Want to be able to select a game from Games and see all tickets for that game.
I've tried all sorts of link/linked combos and can't get this seems to be simple setup to work. Any guidance would be appreciated.
Also:
A) can Tickets be a child to both Partners and Games?
B) do records in the child database have to be created after the field parms in the parent DB are established?
Thanks in advance for any help