S
sashabaz
I am trying to create 2 combo selection boxes (the second depending on what
is chosen in the first). This is to deal with Departments and Positions.
So, for example, I select the Cleaning Department from the Department combo
box. This then only shows the positions which are related to the Department
selected (i.e. Vacuum cleaner, duster, etc...) in the Positions combo box.
So far I have created 2 tables for this. A one-to-many for the positions to
departments. The departments table then links to the staff table (where the
job title is shown with deptartment).
The positions table only includes the position names and a primary key.
The Department table holds the position IDs, the Department name, and the
Department ID. Department ID is then linked in the Staff table.
Hope someone can help.
Thanks,
Sashabaz
is chosen in the first). This is to deal with Departments and Positions.
So, for example, I select the Cleaning Department from the Department combo
box. This then only shows the positions which are related to the Department
selected (i.e. Vacuum cleaner, duster, etc...) in the Positions combo box.
So far I have created 2 tables for this. A one-to-many for the positions to
departments. The departments table then links to the staff table (where the
job title is shown with deptartment).
The positions table only includes the position names and a primary key.
The Department table holds the position IDs, the Department name, and the
Department ID. Department ID is then linked in the Staff table.
Hope someone can help.
Thanks,
Sashabaz