Simple Dynamic Drop Down
First time with FileMaker and absolutely love it.
Could someone please advise me as to how I can create a very simple dynamic drop down:
1. I plan to have two dropdowns (possibly more in the future)
2. The first will be Department.
3. Depending on which value I select in department, I want Category (the second drop down) to be populated with categories that are defined by the selected department.
Any help would be greatly appreciated.
Thank you in advance for your time.