E
ehadden
I am new to Access, so technical jargon is tough for me, but I am trying to
generate a form for data tracking. When I click on one field in the form
(combo box), I want a subsequent field to be limited to items that are
related to the first. Example: In the form, when I click on the particular
grade level in the combo box, I want only the teams from that grade level to
show in the next field box. After I click on the appropriate team, I want
the only the students from that team to show. I already have the necessary
tables set up with Grades, Teams, and Students. All of this data is being
pulled from separate tables, but is being combined to populate records in
another table.
generate a form for data tracking. When I click on one field in the form
(combo box), I want a subsequent field to be limited to items that are
related to the first. Example: In the form, when I click on the particular
grade level in the combo box, I want only the teams from that grade level to
show in the next field box. After I click on the appropriate team, I want
the only the students from that team to show. I already have the necessary
tables set up with Grades, Teams, and Students. All of this data is being
pulled from separate tables, but is being combined to populate records in
another table.