Hello,

I have a question if it is possible to create a dynamic picklist when choosing from a multiselect field. In more detail, I want to classify the industrial sectors a company belongs to (using the european NACE codes).

When selecting multiple sectors, a more detailed list of more specific sector criterias should emerge in a new multi select field, but only options that corrspond to the selected sectors that have been chosen in the first place.

I have 4 forms:

industrial_ sector_level1_form

 Field: level1_sector (single line)

 Field: Explanation_level1 (single line)

industrial_sector_level2_form

 Field: level2_sector (single line)

 Field: level1_sector_lookup (loockup from level1_sector in industrial_sector_level1_form)

 Field: Explanation_level2 (single line)

industrial_sector_level3_form

 Field: level3_sector (single line)

 Field: level2_sector_lookup (lookup from level2_sector in industrial_sector_level2_form)

 Field: Explanation_level3 (single line)

Company_mapping_form

Field: Company_name (single line) 

 Field: level1_sector_multiselect (multiselect lookup from level1_sector in industrial_sector_level1_form)

 Field: level2_sector_multiselect (multiselect lookup from level2_sector in industrial_sector_level2_form but only with options who match the level1_sector_multiselect values)

 Field: level3_sector_multiselect (multiselect lookup from level3_sector in industrial_sector_level3_form but only with options who match the level2_sector_multiselect values)

The first 3 forms just contain the informations to the specific sectors, whereas the last form contains the company's Name and the matching industrial sector of the company. With the different Levels of sector classificiations, I want to narrow down the possibilities,

I attached an Excel file on which I want to clarifiy this. In level1_sector_multiselect field, A,B,C,... can be chosen. In the  level2_sector_multiselect, only the options emerge who match the level1_sector_multiselect field e.g. if A and B are chosen in the first field, 01, 02, 03, 04, 05, 06, 07, 08 and 09 are the only options in the level2_sector_multiselect field.

I hope my Intention is clear. I'm looking forward for responses. Thx

Best,

Hans