Query Question i think

[Guest]

Hi all
i have created a database with good functionality i believe.
However i am a newbie and i need some help with one last mountain. I have a
table called products which is my master table if you like. The particular
fields of this table i need this functionality for are Brand, Make and Model.
At present these field are interfaced by combo boxes on my main form which
allows users to enter products into our system. I have setup three tables -
brand - make - and model which are populated with the common parts we use and
they are used to auto populate the fields on my main part entry form and then
store the data in the products table against the part. Pretty simple - static
data list, works well. Well i want to take it one step further, we will over
time have many makes and models through the place, the list that i pull from
data from will become very large with makes and models. Is there some way to
filter the list so that when a user selects IBM for example in the brand
combo box that only IBM parts are shown in the makes and models combo boxes
to select so that the list is short. I belive a query is the way to go but i
just dont know how to go about it to get this fucntionality out. The other
issues i can see are that maybe the brand, make, and model should be in the
same table ?. If i can get over this one im set !.

Thanks for your help

Phenonm

 

[John Nurick]

I think this will help. You'll need to have a field in the Makes table
to hold the brand for each make, and a field in the Models table to hold
the make for each model.

http://rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboBoxes.mdb