I set up a football league management database. I enter teams and contact details, enter results and run reports to calculate tables.
I have seperate databases for each league. What I want to do is have one database, enter all teams and their relevant leagues etc. When I enter results on a form I want to select the relevant 'league' from a combo box(or another method), then select the 'team' from another combo box, but I want the 'team' combo box to only show teams from the chosen league.
To filter teams by which league they play in.
i.e.
When I choose a different 'league' I would see another set of teams in the 'team' combo box.
I hope this is clear.
Thanks in advance.
Russ
I have seperate databases for each league. What I want to do is have one database, enter all teams and their relevant leagues etc. When I enter results on a form I want to select the relevant 'league' from a combo box(or another method), then select the 'team' from another combo box, but I want the 'team' combo box to only show teams from the chosen league.
To filter teams by which league they play in.
i.e.
When I choose a different 'league' I would see another set of teams in the 'team' combo box.
I hope this is clear.
Thanks in advance.
Russ