Dependent Combo Boxes

[schwabe]

Hello all,



I'd like to set up a form with dependent Combo Boxes. How do I do that?

Just in case, I'm adding a few detail:

I have a set of customers and for each customer a set of projects and for each project I have several bills. What I'd like to do with this form is to have a combobox to choose the customer (no problem, here). Once a customer is chose, only the projects with this customer should be given as selection of a second ComboBox.
Once a project is selected, I'd like to have another ComboBox giving the numbers of the bills which refer to this project.

Thank you a lot for your support!

[pbaldy]

Sounds like cascading combos:

Baldy-Cascading Combos

[schwabe]

Hello Paul,

thanks for your reply / exactly what I was looking for.

However, there is still one thing:

I have one table (tabCustomer) with CustomerID and CustomerName and another table (tabProject) with ProjectID and ProjectName and a column with links to the CustomerID. How do I proceed then?

Thanks!

[pbaldy]

The table layout doesn't really matter. It's a matter of coming up with the appropriate SQL, like:

SELECT Blah
FROM tabProject
WHERE CustomerID = 123

where 123 comes from your combo. So either method will work just fine.