Good Morning
I am putting together a plan for a database which can be used to keep track of our client's rates, supplier cost and profit. I am however struggling with which tables would be best suited ?
So far I have the following which does not seem to be correct - and I cannot get my head around a better solution:
tblClients - would contain basic client information
tblInventory - would be the various services we offer
tblPriceList - (lookup inventory code from "tblInventory" ) and also contain the customer's rate.
tblSuppliers - basic supplier information
tblSupplierRates - (lookup inventory code from "tblInventory") and also contain the supplier's rate for that particular service
Reports:
Profit Report - reflects the list of clients - along with the client rate from tblPriceList - and compares it with the supplier rate from tblSupplierRates
- the problem is that more than 1 supplier can have a rate for each different inventory item
Any advice or guidance will be appreciated
Thank you
Did you like this article? Share it with your favourite social network.