views:

313

answers:

0

good_day

created combo-box to view suppliers, sync'd it to another combo-box displaying all products(Product_Name) for that company

I need the Product_Code for the Product_Name(that was selected)(same table), in a text-box in the same form

ie..Products combo-box I have to view Products by name and once selected the closed combo-box must display the Product_Name, So I can not save the Product_Code,when using the wizard.

How do i sync the text-box to display the product_code, of the Product that was selected in the combo-box

I did get it to work when product_code and product_name is view'd in combo-box but then in the wizard of it I selected to save Product_Code .. ie. so once selected only the code shows and not the name