In my database, I have Products table and Orders_Details table that contains
Product_ID field and they have one to many relationship.
On Orders_Details subform, I have a combobox Product_ID which is a bound
control. From the pulldown list, I can have Product_ID, Product_Name and
Price listed. After whichever product is selected, I want the combobox to
display both Product_Name and Price but it can show only the Product_Name
field.
I’m also thinking of use another unbound field to display the price
separately, but I have problem making it work.
Can anyone make some suggestions to me?
Thanks,
Guangdew
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1