hello
I begin to design a simple Ms Access program to management a small warehouse(store) (two warehouse)
the manager need to :
-add product ( amount, unit Price, date,) to one of the warehouses.
-sell product ( amount, unit price, date, customer) from one of the warehouses
-know the remain amount at the warehouse when he ask about it.
what tables do I need ?
Customer Table
Products Table
Transaction Info
Transaction Details
??