OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Database Design (http://www.officefrustration.com/forumdisplay.php?f=27)
-   -   Modify Northwind (http://www.officefrustration.com/showthread.php?t=1116744)

Abdul Shakeel[_2_] May 24th, 2010 06:43 AM

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


All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
OfficeFrustration.com