I'm trying to use the lookup wizard to create a dropdown box that only shows options based on the selection of a previous dropdown box...
Table structure is...
tblMaster tblGroups tblGroupSubgroups tblSubgroups
MasterID -----> groupID -----> groupID |--> subgroupID ---
groupID groupName subgroupID --| subgroupName |
subgroupID <-----------------------------------------------------------------------
Sample table
tblMaster tblGroups tblGroupSubgroups tblSubgroups
1 1 1 1
1 Group1 1 Subgroup1
2
Subgroup2
So when I select a group in the first dropdown box I only get choice of associated subgroups...
In the case of the sample data I will be able to choose Subgroup1 but not Subgroup2...
For the life of me I can't figure out a way of getting it to work...
I can select a category control of GroupID but only have the option of selecting subgroupID for category field...
Any help will be appreciated...