Help with form & combo boxes

[rnjalston]

I am new to this and would sure appreciate some help. I have 5 tables: Mfg, Product, Brand, Variety, Details. Each related to the next in the order above.



The relationships are such that I can enter info directly into the tables. But what I would like is a form with 4 combo boxes, each filtering the next in the order they appear above. Then entering 3 fields for the Details (Size, Unit, Pkg). Also need each combo to allow additions if not in list.

Please help!

[pbaldy]

The concept is called cascading combos. I demonstrate a couple of methods here:

http://www.baldyweb.com/CascadingCombo.htm