Adding additional info w/combo box

[harix]

I am trying to get my form to add all the product info when I select the product # from the list. All the info I want to enter shows with the product #, how do I get all the other info to post with the product #? I get the product info from products table and trying to update sales table with a form.

Thanks for any suggestions!

Harry