Help with combo boxes

[AnnPhil]

I have a Order form that i would like to use combo boxes when adding details records to the order. For example, my list of products is very long, each product belongs to a Series(category) I would like to create two combo boxes when placing an order. First one to select series, then another one to select product. I would like the product combo box to show only those products related to the series. Seems like a simple task but i am having so much trouble. I tried looking at the Northwind db because it has categories and products but in their order form their combo box just list products and there is no example like the one i want to do. Can anyone help?

 

[WayneRyan]

Ann,

Use the Search Facility here and look for "Cascading", as in Cascading
ComboBoxes. There should be many examples.

Also, try the Sample database forum.

Wayne