designing complex database

  • Thread starter stripedfrog via AccessMonster.com
  • Start date
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.
 
K

KARL DEWEY

Maybe tables like this --
Dealers--
DealID - primary key
Name
ADDR
RMKS

Products—
ProdID - primary key
Name
Unit – Lbs, FT, LG, GL, etc
Price

Dealer-Products—
DealID – foreign key
ProdID – foreign key

SalePersons—
SalesID - primary key
LName
FName
MI
Birth – date
Hire - date

Territories—
TerrID - primary key
Name
Description

SalePersons-Territories--
SalesID – foreign key
TerrID – foreign key
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top