Dear All,

In northwind database that comes with access 2003, how can I make a form
for purchase / received inventory just like customer order, form for this
purpose how many more table do I have to made I am also want to track the
inventory in Transaction table for all the purchase & sales just as below:
TransactionID
TranscationType (Purchase/Sales)
InventoryID
Quantity
Any idea how I can do this??

--
Regards,

Abdul Shakeel