S
stripedfrog via AccessMonster.com
Trying to build a database that has dealer/sales/product/territory
information. Problem is trying to distinguish four different product
territories for the dealers and relate them to the territories of our sales
reps.
example:
Dealer1 prod 1 territory for product 1 Our Salesman's territory
Dealer1 prod 2 territory for product 2 Our salesman's territory
Dealer2 prod 1 territory for product 1 our salesman's territory
Not sure this illustrates it correctly. Basically, when we pull up a
dealer's record we want to know which of our sales people is their rep.
information. Problem is trying to distinguish four different product
territories for the dealers and relate them to the territories of our sales
reps.
example:
Dealer1 prod 1 territory for product 1 Our Salesman's territory
Dealer1 prod 2 territory for product 2 Our salesman's territory
Dealer2 prod 1 territory for product 1 our salesman's territory
Not sure this illustrates it correctly. Basically, when we pull up a
dealer's record we want to know which of our sales people is their rep.