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.
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.