Trying to control the choices displayed in my combo box within a form.
Three separate tables linked at Many-to-Many relationship.
Table 1:
Field1: Categories (many of the same)
Field2: Available Awards (many of the same)
Table 2:
Field1: Category (only one of each)
Relationships: 1-to-many with Table 3 & with Table 1.
Table 3:
Main table with a primary key (person's name) with one of the fields being Category.
Ideally, after user inputs a person's name, they will then go to next field where they will have drop down box listing different "categories" from Table2. AFTER they choose a category, the next drop down box will ONLY list AWARD choices relevant to that particular category as defined by the relationship. Both will then be stored in the main table3. I have no problem with the first part, but I do have problems with the second with limiting Awards Combo box to just those relevant awards. Currently it lists every award regardless. Is it a problem with relationships, query, or ?
Three separate tables linked at Many-to-Many relationship.
Table 1:
Field1: Categories (many of the same)
Field2: Available Awards (many of the same)
Table 2:
Field1: Category (only one of each)
Relationships: 1-to-many with Table 3 & with Table 1.
Table 3:
Main table with a primary key (person's name) with one of the fields being Category.
Ideally, after user inputs a person's name, they will then go to next field where they will have drop down box listing different "categories" from Table2. AFTER they choose a category, the next drop down box will ONLY list AWARD choices relevant to that particular category as defined by the relationship. Both will then be stored in the main table3. I have no problem with the first part, but I do have problems with the second with limiting Awards Combo box to just those relevant awards. Currently it lists every award regardless. Is it a problem with relationships, query, or ?
