Hello
I am writing an access database to link appointing officials to tournaments.
I have a table called Tournaments (contains an auto-number for Tournament_ID and a number field for Contact_ID), and a table called contacts (contains an autonumber for Contact_ID and a number field for Tournament_ID).
I want to be able to open a Tournament form with a contacts subform, select an official and assign them to the tournament. I also want to be able to do it the other way (open a contact form with a tournemant subform).
I can get the subform to view
Umpires may get appointed to multiple tournaments ... tournaments will have multiple officials.
I will then build reports that show by tournament or by official.
Any assistance greatly appreciated.
I am writing an access database to link appointing officials to tournaments.
I have a table called Tournaments (contains an auto-number for Tournament_ID and a number field for Contact_ID), and a table called contacts (contains an autonumber for Contact_ID and a number field for Tournament_ID).
I want to be able to open a Tournament form with a contacts subform, select an official and assign them to the tournament. I also want to be able to do it the other way (open a contact form with a tournemant subform).
I can get the subform to view
Umpires may get appointed to multiple tournaments ... tournaments will have multiple officials.
I will then build reports that show by tournament or by official.
Any assistance greatly appreciated.