I have two drop down boxes. One with clients and the second with the project numbers (each client has multiple projects).
When I select a client in the first drop down I only want the project numbers for that client to be shown in the second drop down box.
So if I select client apple then the second box would have app1, app2
And if I select client orange then the second box would have org1 org2 org3
Right now the second box shows app1, app2, org1, org2, org3
I am using a trial version of filemaker 12 to decide if we should purchase the program