I would greatly appreciate any advice on the following:
I have a 3 table layout;
Teams, Answers, Project.
Teams has primary key of TeamID.
Project has primary key of ProjectID.
Answers has composite key of TeamID and ProjectID.
Teams and Project are linked to Answers but not to each other.
There is no referential integrity on any join.
I would like to create a form to enable an individual to select a specific project from a combo box, and then select specific teams to be associated to the project (the result being that in the main form, when a project is selected, only teams relevant to each project are displayed). I hope this makes sense.
I have a 3 table layout;
Teams, Answers, Project.
Teams has primary key of TeamID.
Project has primary key of ProjectID.
Answers has composite key of TeamID and ProjectID.
Teams and Project are linked to Answers but not to each other.
There is no referential integrity on any join.
I would like to create a form to enable an individual to select a specific project from a combo box, and then select specific teams to be associated to the project (the result being that in the main form, when a project is selected, only teams relevant to each project are displayed). I hope this makes sense.