I'm having problems trying to create a database in MS Access, to do receiving and dispatching of goods.
I need to create a database for a cross shipment depot,there are three points of interest.
Goods Received.
Which do not always have are not standard Products that I can create a Product Table for.
I need to be able to receive the goods. then dispatch the goods at another time.
Goods Despatched,
When dispatching goods it can be part of the shipment or the full shipment. so i need to have some kind of stock control process. ie running totals.
Goods Delivered,
I need to update the despatched Goods to have Deilvey times.
If anyone can help me with how I should start off and where I should create the method of working out a stock table it would be appreciated.
Thanks