Filtering a table from a combo box menu

C

Coz

I have a table that stores all my product types, priceing info specific to my
customers. I am designing a sales order page and would like to have a combo
box that would only display the products that relate to the customer, is
there some way l can have the combo box lookup the customer name column and
display the product and priceing info for this customer only?

I already have a combo box setup that lists my customers names and displays
there invoice details! don't know if this helps!

Any ideas welcomed as i'm completely stuck!

Cheers
 
Top