Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database structure suggestion

Status
Not open for further replies.

realflava

Technical User
Apr 11, 2004
16
DE
I'm looking to implement a database of products sent to retailers.

So..

I can send an Excel sheet (maybe?) to retailer to complete and list the products that he has which I will update on my database.

I don't want user to carry out any data input, just few mouse clicks.

My current structure is:

tblRetailers (RetailerID PK, code, name)
tblProducts (ProductID PK, name, description, price, ...)
tblOrders (OrderID, RetailerID, ProductID)

help will be much appreciated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top