If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can we put two or three sets of data into one combobox?
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 |
Thread Tools | |
Display Modes | |
|
|