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 ?