This issue has been driving me bananas so if someone could help I would really appreciate it!!!
I have created a database to track sales. I have a table called "transactions" and a table called "Transaction Details". The setup is very similar to the orders entry sample database. What I am having problems with is that I want to have a combo box list the product name and price per unit. I am able to build the combo box in my transaction details subform through the product ID field that is based off of my products table that, when opened, shows two columns - one with the product name and the other - the price. What I can't figure out how to do is to get the selected price in the combo box into the unit price text box next to the combo box.
I have the the same setup as the order entry database but I can't see how they were able to perform this operation!?!?!
If anyone could help with this problem I would really appreciate it!!!
Thanks in advance...
I have created a database to track sales. I have a table called "transactions" and a table called "Transaction Details". The setup is very similar to the orders entry sample database. What I am having problems with is that I want to have a combo box list the product name and price per unit. I am able to build the combo box in my transaction details subform through the product ID field that is based off of my products table that, when opened, shows two columns - one with the product name and the other - the price. What I can't figure out how to do is to get the selected price in the combo box into the unit price text box next to the combo box.
I have the the same setup as the order entry database but I can't see how they were able to perform this operation!?!?!
If anyone could help with this problem I would really appreciate it!!!
Thanks in advance...