Question 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 ?

 

[DavidAtWork]

I don't understand your Suppliers table,
"table 03 Suppliers : (s.no , sup01 ,sup 02 , sup 03)"
are you suggesting a table that will hold a different supplier name in each of the fields
sup01 ,sup 02 , sup 03 etc
If so I would reconsider your table design and consider the relationships between tables, ie what are one to many to achive the desired level of normalisation

table 01: Products should have fields such as productID(PK), productName, productType, productPrice, supplierID etc (if one product can have more than one supplier, you'll need a junction table to link product to suppliers)
Your Suppliers table should be designed like SupplierID (PK), supplierName, supplierType etc
a Supplier could have many Products etc
If a Purchase_Order could have many Products, you would also need a junction table such as PurchaseOrderItems

It's important to get your table design correct before you start to consider any forms

David

 

[shazi9b]

Thanks David
I made this file please review it

 

[shazi9b]

this is my file attached

 

[gemma-the-husky]

this is a really good inventory database sample

http://office.microsoft.com/en-gb/templates/inventory-management-database-TC001018458.aspx