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
|
|||
|
|||
show 2nd field when combo box choice is made
Greetings:
I have a db for clients and their purchases. In my attempt to further normalize my tables, I have created a new table to list the products clients can purchase. So now i have 3 tables. One has the client info, the 2nd has the individual orders (ID, client foreign key, product (stores combo box info) , order date, quantity ordered and a price number field to hold the info this question is about) and the 3rd has the list of products and the price of each product. I have a form to enter the client info and a subform to enter each client's order info. The order subform has a combo box to choose the product ordered. When I choose the product,I would like the price from the product table to go into a field in the subform and be recored in the order table. Is this possible? Thanks, Scott -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|