I’m working on building an app for ordering coffee and various food items. Each item has a category, and I’d like to include options as you add them to your cart that are based on category of the item (i.e. If you are ordering a coffee, you get checkboxes for cream, sugar, etc, but if you are ordering a breakfast sandwich, the checkboxes will show hot sauce)
Following a suggestion I found elsewhere on this forum, I set up a table with all my choices, each one listing its appropriate category, then I created a relation between the category and my category table. Then I created a lookup column to list, for each checkbox the appropriate menu items (i.e. next to cream, you see Americano, Coffee, etc and next to Hot Sauce you see various breakfast sandwiches) I thought I was in the home stretch when I went to filter the choice component by my lookup column, but I can only select ‘is empty’ or ‘is not empty’ - for some reason I can’t check whether a lookup column contains the screen item.
Is there some way to get this filter to work or another approach altogether that might help me get this working? Thanks for any assistance you can provide!