Hi everybody
i need your support in the following :
i need to make inventory management program by MS access
my idea depended on 3 tabels :
1- the first table called goods list that table contains all the items in the store and i need this list to start the work with and that table contains 3 fields item,unit and quantity
2- the second table called the addition table, that table stored data about the goods invoices and this data wrote in addition voucher this data like :date of process, the supplier name, voucher no, invoice no, items, item unit,recived quantity, item unit price, total price, notes (this table stored all data about goods that come in the store)
3- the third table called exchange table that table stored data about goods go out of the store this data like : date of process,voucher no, cost center, items, item unit, quantity,
what i need to do is make control on the stock know i have
first stock in the first table
& come in goods in second table
& out goods in third table
i want when i add item in second table the stock increas in the first table
and when i dismissal goods in the third table the stock for the same item decrease in the first table
anybody can help me guys