Populating textbox and listbox values from MS Access tables
-
Hi.. I have a form which is like following: Sup.Id: tbox1 S.Name:tbox6 ->When i select 1 it should populate the textbox6 with the proper name? how to do that? Prod_Name: listbox1...It should only show product name once not twice how to do that? Prod_Type: listbox2 -> How to view only product type e.g. F,H and T CostPrice: tbox4 -> It should calculate from product table? Prod.TradePrice:tbox5 Now as you see i have two tables Suppliers and Products.. In products table i have e.g. p.name=prodA p.type=F p.Price=100 p.name=prodA p.Type=H p.Price=50 Suppliers Table: S.id=1 S.Name=InStock I will be very thankful to you pls help out...
-
Hi.. I have a form which is like following: Sup.Id: tbox1 S.Name:tbox6 ->When i select 1 it should populate the textbox6 with the proper name? how to do that? Prod_Name: listbox1...It should only show product name once not twice how to do that? Prod_Type: listbox2 -> How to view only product type e.g. F,H and T CostPrice: tbox4 -> It should calculate from product table? Prod.TradePrice:tbox5 Now as you see i have two tables Suppliers and Products.. In products table i have e.g. p.name=prodA p.type=F p.Price=100 p.name=prodA p.Type=H p.Price=50 Suppliers Table: S.id=1 S.Name=InStock I will be very thankful to you pls help out...
Any help please...:confused: