On my app o have a 4 level table subtable set for a location: Region / Sector / Section / Base. I need to have the user selecting first the [Region] then, only the [Sector] for the selected [Region] should show on the dropdown [Sector] control, then only the [Section] set for the the selected [Region].[Sector] should show on the dropdown.
All the controls have specific proper names, e.g. [frmfld_Region] for the dropdown control related to Region.
My question is: how do I do it? How do I ensure that the dropdown list is properly managed? (a simple tree as in datasheet view would do ... but I can't simple use it as I loose the "control" management.