I have a conditional value list that has field Category then underneath is field Subcategory.
My problem can be broken down into these steps:
- User selects Furniture as Category from drop down.
- User selects Chair as Subcategory from drop down.
- User goes back up to Field Category and changes it to China.
- User closes record with Category: China & Subcategory: Chair
I would like filemaker to pull down Subcategory once the user Selects a value for Category so I could prevent conflicting values.