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.
Thank you for your post.
Please see the following Knowledge Base article "Creating Conditional Value Lists" on on our web site:
This should get you pointed in the right direction. If you have any questions or need clarification, please let me know.