Hey all, some tables to set the stage (with an arbitrary food theme): [image] Basic stuff right? Next step: a ‘recipe maker’, i.e. narrowing down possible food items by the selected category or categories. Like this: [image] UPDATE for clarity: selecting “fruit” as category should provide selec…

Here’s my take on it. A bit more complicated than I’d want to but it appears to work for all cases. I initially arrived at the same formula as @Ander , but as you @mr_motus observed it breaks for more than 1 category. This is because Contains is inherently an OR function. The solution for this need…

Apples & Oranges: select items using an advanced category filter. Is this possible?

Ander March 2, 2019, 3:18pm 2

@mr_motus

Maybe this will help, as a starting point. You can customize it to your specific requirements.

1 Like

How to Catch lookup?

Topic		Replies	Views
How to Catch lookup?	5	672	September 2, 2022
Defining the options of a Select List in a Table based on values of a row in another Table	2	722	December 11, 2023
Filter results shown in a select control?	4	1619	February 15, 2019
Filter a multi-select column by a multi-select control?	4	1727	December 12, 2018
Display Filter - "Contains" a list option	1	521	September 12, 2018

Apples & Oranges: select items using an advanced category filter. Is this possible?

Related topics