Quick question. I 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); then once a product type is selected, the item field drop-down box will pull from the selected type's table... Follow? I know it's doable. Just.. How?