R
ryan.fitzpatrick3
I made a form to look up 3 table fields. What I have is a table with a
filter section of items;
field 1 is GROUP
field 2 is CATEGORY
field 3 is CLASS
it would lay out like this
GROUP CATEGORY CLASS
1 0 1
1 0 2
1 1 1
1 1 2
1 2 0
1 3 0
1 3 1
2 0 0
2 0 1
ETC
In the table It looks like this, category and class are sub filters of
the field before it, and I have 3600 total selections. Now I made a
form with 3 combo boxes where the 1st gets GROUP, 2nd gets CATEGORY,
and 3rd gets CLASS.
Now in my query I linked the GROUP to the group combobox selection,
CATEGORY to the category combobox and CLASS to the class combobox. and
the rowsource reflects the table that has all 3600 selections.
Is there away to make category combobox only select records that match
up with group? So if I select 1 for group then only 0,1,2,3 are the
only selections for category and therefore depending on the selection,
lets say category I chose 1, the class would have the options of only
1, 2. I've done this in the past when I had tables that were subtables
of each other but not from 1 table with 3 fields. Thanks.
Ryan
filter section of items;
field 1 is GROUP
field 2 is CATEGORY
field 3 is CLASS
it would lay out like this
GROUP CATEGORY CLASS
1 0 1
1 0 2
1 1 1
1 1 2
1 2 0
1 3 0
1 3 1
2 0 0
2 0 1
ETC
In the table It looks like this, category and class are sub filters of
the field before it, and I have 3600 total selections. Now I made a
form with 3 combo boxes where the 1st gets GROUP, 2nd gets CATEGORY,
and 3rd gets CLASS.
Now in my query I linked the GROUP to the group combobox selection,
CATEGORY to the category combobox and CLASS to the class combobox. and
the rowsource reflects the table that has all 3600 selections.
Is there away to make category combobox only select records that match
up with group? So if I select 1 for group then only 0,1,2,3 are the
only selections for category and therefore depending on the selection,
lets say category I chose 1, the class would have the options of only
1, 2. I've done this in the past when I had tables that were subtables
of each other but not from 1 table with 3 fields. Thanks.
Ryan