There is a concept that I have yet to grasp. I am working on an inventory database. Each item belongs to one of three groups. Each group has a to department which breaks down to a sub-department.
I have a table with one record for each sub-department that has a field for group, department, and the sub-department. How do I get my drop downs for departments and sub-departments to reflect only those values for the value of the prior values.