I have a catalog with 3 tables: Type, Make, Model.
Here are the columns:
Model: Name, Type, Make
In a 4th Inventory table, I want the user to select a model. I really only need the Model column.
However, the Model table contains a lot of rows. To simplify the operation for the user, I would like the user to follow 3 steps:
- Type selection
- Brand selection
- Selection of the model with a reduced list automatically filtered by the above steps.
So I added the Type and Brand columns in this Inventory table.
How can I filter the list of Models with 2 Type and Brand columns.
I saw that we could select a filter present.
In my case, I want to filter on 2 columns. So I tried using the custom filters but I’ve been trying things for 2 hours and can’t do it.
Do you have any idea how to create this custom filter?