Suppose I have a following table:
I want to have a form with 2 dropdown lists:
BRAND MODEL COLOR Audi 100 Beige Audi 200 Red Renault 300 Black
- one for Brand (with Audi and Renault),
- one for Model (with 100, 200 and 300).
Also, the form would have this very table as a report or something.
I want to be able to select Audi, and then the second dropdown list would only show 100 and 200, and the report would only show the first two rows.
Then I select 200 in the second dropdown list, and the report only shows the second row.
It doesn't have to be exactly like this, it doesn't even have to be a form, but i want a step-by-step narrowing search with results displayed on each step.
Is it possible in MS Access?