Filter based on drop-down menu

0 votes

Do you have steps on how to accomplish filtering from the drop-down menu?
For example, I have a table called CONTROLLER in which I store following 3 items:

Second table called CHIPSET. Now this table could have multiple items that are associated with one controller, lets’s say Intel.
As you can see, filtering here works fine

So far so good...
Now... I have another table called AOC_CHIPSET
In here I would assign a card to the controller and chipset. What I am looking at here is to be able to select controller (like Intel) and all ONLY the chipset items that are assigned to Intel like the picture above shows would show up under the Chipset drop-down.

Here the AOC_CHIPSET Table info with PK/ FK Info

in How To by (790 points)

1 Answer

0 votes
Best answer

If I read your question correctly, you are looking for instructions on implementing a cascading lookup.

If so please see: Cascading Lookups/Dropdowns

by (50.7k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer