Need Help:Basic Inventory System

[shazi9b]

Hello
I am using MS Access 2007 to develop inventory system .I created 3 tables details are given below
table 01: Products: (s.no , keyboard,mouse,agp,lcd)
table 02 Purchase_Order (S.no , date, supplier ,product,quantity,rate,amount)
table 03 Suppliers : (s.no , sup01 ,sup 02 , sup 03)
Purchase order form created via table (purchase_order)
i need help to select product which i purchased while entering data in form . how can i do it ?

[June7]

Can each purchase order have more than one product? Need another table for order details. Then use form/subform arrangement.

Might want to check out http://office.microsoft.com/en-us/te...010206882.aspx

[shazi9b]

yes every purchase order contains more than one item like (lcd+agp).inventory templates doesnot fit at my requirements . i will try to develop different one .

[June7]

It might not fit but might get some ideas from it.

Did you understand about another table and form/subform for data entry/edit?

[shazi9b]

i am atatching my database please review it

[June7]

My advice is the same. Need another table OrderDetails. It will have records to associate products with order number. The PurchaseOrder table will have the parent record with order number and date and supplier.