Lookup and list filtering

[TSSTechie]

Firstly, is it possible to create a drop down list in a table that gets it's data from two different tables. i.e. An instruments table, an items table and a table that they are both linked to (table 1). In Table 1, can there be a drop down list that displays all the instruments from the instruments table then, in the same list, all the items from the items table underneath it.

And secondly, can I create a form with 3 drop down menus on.

Instrument Type Instrument Make Instrument Model

I want to be able to select an instrument type. This will then filter the instrument make list to show only the makes available for that particular instrument. Once a make is selected, the instrument model list will be filtered to just the models available for that type and make of instrument and, finally, when the model of instrument is selected, a new form pops up with all the information about that instrument.

If all of this is possible, can someone please tell me how as it's got me completely stumped.

Thanks in advance

May The Force Be With You

 

[GoDawgs]

You can do this on a form, but not in a table. Check out filtering combo boxes or something similar on this site, I've seen plenty of posts about it. Hope that helps.

Kevin

 

[dhookom]

There is a small sample database at

http://www.rogersaccesslibrary.com/TableOfContents2k.asp

showing how to use cascading combo boxes.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.