Newbie question on databases

[AL]

In Access 2000 I am using the stadard order entry
database. In the orders form I want certain products to
show in the drop down box for certain customers and
differnet products to show up in the drop down box for
other customers. I don't want all of the products to
show up for each customer. Do i have to create some sort
of relationship in the products table by assigning a
customer ID to the products they offer? Any help would
be great. AL

 

[Francesca Sullivan]

Hi,

You would need to assign some type of customer type to differentiate the
customers within the customer table. Then when you create the record
source for the customer on the combobox, add the criteria to restrict
products when the customer type is whatever.

FS