G
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 enters
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 field on my entry form and then store the data in the
products table. 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 that only IBM parts are shown in the makes and
models 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 functionality 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
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 enters
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 field on my entry form and then store the data in the
products table. 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 that only IBM parts are shown in the makes and
models 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 functionality 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