Question about organizing with multiple tables..?

[SSpiro]

have a form with a subform. The main form is designed for a quotation work
sheet. The subform has fields with qty, item, desc, item cost, and extended
cost. The item field is a drop down box that pulls from a product table.

We want to clean this up and make it even easier. Say the customer has many
different types of products (THOUSANDS) and they want to group each product
type into, well, a type. e.g., Boxes table will contain blue, purple, green,
brown, etc (just an example)

Is it possible to have a drop-down box that lists the available product
types (each type has its own table, i.e. Boxes, Bags, Misc Supples); then
once a product type is selected, the item field drop-down box (in the
subform) will pull from the selected type's table... Follow?

I know it's doable. Just.. How? Thanks in advance.

 

[ChrisJ]

You appear to be asking about "cascading combo boxes" where the contents of
cboB depends on the selection from cboA.

You're right. This is very doable.
What you need to do is re-write the rowsource sql statement for cboB with a
where clause that reflects the selection in cboA. Place this code in the cboA
"click" event.
To be more specific, info on table names, field names, primary keys, cbo
names and rowsource sql will be needed.