Hello, thank you for reading this question, and possibly (hopefully) pointing me in the right direction. I've got a basic database that I've been working on, and adding items as I see necessary. The database is basically used for keeping track of painting jobs that we have come in. We have a list of products that we use from 4 different manufacturers. What I'd like to be able to do is use a combo box to select a manufacturer, and then have multiple combo boxes below (4) that would only display data that is part of the original combo box selection. For example, we use SHERWIN WILLIAMS, INTERNATIONAL, AMERON, and CARBOLINE products. Each of these manufacturers have different products such as primers, innercoat, finishcoat. So when I select, lets say SHERWIN WILLIAMS from the first combo box, I'd like the next 4 combo boxes on my form to only have the option of selecting from the products that are from SHERWIN WILLIAMS. I would appreciate any help you can offer.
Thank you,
- Jim