Combo-Box/Table Issues

[Gary]

I have a simple database, and I am trying to figure out the best way to set
up the tables to work best with the form that is created. Basically there is
a manufacture field, and a product series field. When I chose the
manufacturer from the drop-down combo-box on the data access form, I would
like it to filter the product series combo-box drop-down to only show the
product series associated with the manufacturer. There is a long list of
manufactures and each will have anywhere from 1-100 product series. Anyone
have any suggestions on how to set up the table(s) to get this to work? Or
how to set up the combo-boxes of the product series, to filter the results
based on the selection of the manufacturer combo-box? I’m not an advanced
user, but I can do some simple coding if guided in the right direction.

I have a table created now with manufacture, and one created for product
series that has a manufacture field which is relational to the manufacturer
table. This was my initial attempt, but can easily be changed as there is no
real data input into the tables yet.

 

[golfinray]

I would start by going to either martin green at www.fontstuff.com or allen
browne at www.allenbrowne.com and look at their examples of cascading combo
boxes. Both are excellent.