S
Snide
I am creating a db for a trouble call system. I am going to have the user
select their department via a lookup table from a combo box (I am limited to
only 6 departments). Then when the user selects the department a second
combo box selects a division from said department, each department will have
their own table with a list of divisions within. There will be
approximately one table of divisions for each department. Now here is what
I need these tables to do. The department that is selected triggers only
the divisions within that department, I don't want to see any other division
from another department.
How can I do this? Thanks.
Snide
select their department via a lookup table from a combo box (I am limited to
only 6 departments). Then when the user selects the department a second
combo box selects a division from said department, each department will have
their own table with a list of divisions within. There will be
approximately one table of divisions for each department. Now here is what
I need these tables to do. The department that is selected triggers only
the divisions within that department, I don't want to see any other division
from another department.
How can I do this? Thanks.
Snide