Automatcially Select Specific Child Record
I am building a golf pool management application and just trying to automate one of the tasks as a record in generated. For now the pool is comprised of three related tables. Pool Entrys (the people...
Forum Discussion
Any reason you wouldn't have them select the tournament they are interested in when they create an "event field" entry?
Seems to me like you'd want to have "Contestants (pool entries)" be able to have multiple "Tournament Entries (Event Field)". Then each "Tournament" also has many "Tournament Entries".
Then once you create a "Contestant" once, they could enter all the tournaments available.
Seems like your tournament to entries relationship stated above is backwards.
Additionally, I don't think you should have your contestants related to the tournaments directly. They will only be joined via the "event field" table.
Just ideas.
Seems to me like you'd want to have "Contestants (pool entries)" be able to have multiple "Tournament Entries (Event Field)". Then each "Tournament" also has many "Tournament Entries".
Then once you create a "Contestant" once, they could enter all the tournaments available.
Seems like your tournament to entries relationship stated above is backwards.
Additionally, I don't think you should have your contestants related to the tournaments directly. They will only be joined via the "event field" table.
Just ideas.