Combo box values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I created a table with two combo boxes related to one table with two fields
(Customer and Project). So for each Customer I can have one or more Projects.
Now, I would like to have the values appearing in the second combo box
(Project) related to the choice I made in the first combo box (Customer). I
suppose I have to add some criterias in the SQL Statement of the second combo
box row source, but what will be those criterias? (don't know SQL yet)

Hope my question is clear?

Thanks in advance.
 
Back
Top