AnsweredAssumed Answered

Filter a Form List Lookup control by multiple previous controls values

Question asked by harfmt on Aug 1, 2016
Latest reply on Mar 13, 2017 by emha

Hi

I want a drop down list of employees filtered on both the Department and the Crew within that department as per the table below. As Form List Lookup controls only provide the ability to filter on one control value, is there a way to filter on both the previous control values?

 

I tried creating a view and wanted to build the 'Source view' name from the values selected in the two previous fields (e.g. ProductionBilby via Item Properties), but that doesn't seem to work.

   

Department

Crew

Employee

ProductionBilbyBilbyProductionEmployee
ProductionDingoDingoProductionEmployee
ProductionDragonDragonProductionEmployee
ProductionGeckoGeckoProductionEmployee
WorkshopBilbyBilbyWorkshopEmployee
WorkshopDingoDingoWorkshopEmployee
WorkshopDragonDragonWorkshopEmployee
WorkshopGeckoGeckoWorkshopEmployee
DrillBilbyBilbyDrillBlastEmployee
DrillDingoDingoDrillBlastEmployee
DrillDragonDragonDrillBlastEmployee
DrillGeckoGeckoDrillBlastEmployee

Outcomes