Scenario:
Department A has divisions 1,2,3
Department B has divisions 4,5,6
I want my form to work such that if I choose Department A from a
"Department" combo box, that only 1, 2, and 3 show up in the
"Division" combo box and if I choose B then only 4, 5, and 6 are
available.
I have a Dept. table, a Dept_A_Divisions Table and a Dept_B_Divisions
table. The combo boxes (along with other fields) will provide input to
the main table.
I've searched through help files and tried a variety of things
(different queries, expressions, functions), but I think I'm missing
some small piece (screwing up syntax possibly). Hopefully I'm making
it harder than it really is and there is some simple solution to my
problem. Any help would be greatly appreciated.
TIA
Rick