Menu

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:
Intel
Mellanox
Broadcom

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
https://photos.app.goo.gl/4U18UgbyyZrSdF13A

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.
https://photos.app.goo.gl/2oRknmraHQ1CckBPA

Here the AOC_CHIPSET Table info with PK/ FK Info
https://photos.app.goo.gl/WmRkEhc84yaDz1Am6

in How To by (780 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 (44.5k 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
...