TableDesign-HR

[Donna Brooks]

I have an HR database that I am creating an input form
for. I have about 10 departments and numerous positions
under each department. When I pull down the department
combo box and select a department, I want only the
positions under that department to show up in the
positions combo box? I'm not sure if I'm headed in the
right direction or not. I have started a table called
DeptIDs and then i have another table called positions
Ex. DeptIDs Positions
1 Nursing 1 RN (position under Nursing)
2 Plant Operations 1 LPN (position under Nursing)
3 Dietary 1 Ward Clerk (" ")
4 Clerical 2 Housekeeping (under Mainten)
5 Therapy 2 Maintenance Asst. (" ")

Please help.
Thanks a bunch.
Donna Brooks

 

[Lynn Trapp]

Donna,
Yes, you appear to have a correct design. To Synch your combo boxes, you
need to put a reference to the Dept combobox in the criteria for your
Positions combo box. Then, on the AfterUpdate event of the Dept combo box
requery the Positions combobox.