Have the values in one combo box be filtered based on what went into another combo box
Here's what I'm facing:
In this scenario we may have 20 Organizations with 30 Department Addresses. If I put the Org's in one combo box there of course would be 20 selections. If I placed all the Department Addresses in the next combo box there would be 600 selections and nothing assuring that the Department Address chosen was in the correct Org.
If Org 1 is chosen then the next combo box selection will be only those addresses under Org 1. If Org 2 is selected the next combo box selection will be only those Department Addresses under Org 2
Organization Department Address
Org 1 100 Washington Street
30 Congress Street
50 State Street
Org 2 200 Franklin Street
450 Gloucester Street
700 Newbury Street
Thank you,
Robert