I'm working on an activity tracker, users will select the Team (choice of three; AA, BB, CC) and the Type (choice of two; AdHoc or Regular) and i need to use those two values to filter a lookup list of tasks.
For example, this is the list i am trying to get data from, based on team and type fields the user selects i would like to return the third column.
|BB||Regular||Applicability of New Rules|
|CC||Regular||Scope of Permission|
|CC||Regular||Register Metrics Report|
|BB||AdHoc||Meeting set up|
|BB||AdHoc||Formatting (In word or PPT)|
- The Lookup control doesn't give an option to use multiple criteria to filter.
- I tried creating a helper column concatenating the two fields in the list and a calculated value in the form doing the same - the Lookup control filter doesn't work with the calculated value
- Cascading lookups as described here won't work because any of the Teams can have either of the Types and as far as i can see that solution reqiures the second field to be exclusive to the first field.
- List Lookup filter doesn't give the option of filtering by a variable
Any help or advice would be highly appreciated.