I've got two combo boxes: one bound to a field called 'Group', the other to a field called 'Type', in the same table. The contents of the combo box come from similarly-named lookup tables: GroupList and TypeList. However, here's the rub: each Type is a member of a Group. If the user selects a different Group in the combo box, I want the user to only see those Types in the second combo box that are related to the Group just chosen:
SELECT Type WHERE TypeGroupID = CBOGroup;
... something along those lines. I'm having problems getting this to work, probably because the two combo boxes are bound to table fields. Any ideas?
SELECT Type WHERE TypeGroupID = CBOGroup;
... something along those lines. I'm having problems getting this to work, probably because the two combo boxes are bound to table fields. Any ideas?
