View Single Post
  #1  
Old May 24th, 2010, 06:43 AM posted to microsoft.public.access.tablesdbdesign
Abdul Shakeel[_2_]
external usenet poster
 
Posts: 99
Default Modify Northwind

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
Ads