Forum Discussion

Aaron1040's avatar
Aaron1040
Copper Contributor
Oct 23, 2020

Cascading combos, filtering or something else

Hi all

Hoping for some advice or to be pointed to the correct terminology so I can research further.

I have a table of equipment, each of which can have multiple suppliers and also have multiple attachments.

I’m looking for a way to firstly filter by the specific piece of equipment (always one selection) then filter by attachments (typically multiple Selection) which should leave me with only the list of suppliers who can fulfil that requirement.

Thanks
access
  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    Oct 25, 2020

    Aaron1040 
    The good news is that what you describe is a fairly common requirement and there is, in fact, an established method for handling it. It is commonly referred to as "Cascading Comboboxes". The "upsteam" control (which is usually a combobox, but could be a listbox) is based on the higher level category. The "downstream" control (again, combo or list box) is based on the lower level category and it is FILTERED by a selection made in the upstream control. The after update event of the upstream control is used to apply that filter to its downstream partner. 

    Searching on the term cascading combobox should turn up a plenitude of discussions and examples. 

Resources