Hi Fellows...

"Combo box that links records from two tables in one form..."

I have two tables. A Product table with fields Prod_id, Price and description. On the other table, Transaction table, I have Prod_id, Invoice_id and Quantity.

I have a combo box with data from the second table which displays invoice_id, prod_id and Quantity on textboxes. I want to click on a certain invoice_id on the combo box and also the price from the Product table should be shown in the form.

Thanks

TK, Novice VBA Programmer, RSA

Hi Takawera,
Assuming Prod_id on the Transaction Table is the foreign key for Prod_id on the Product Table.
If that is the case, I would create an inner join query on your form, including both those tables.
In design mode, insert the price field onto your form whicn includes your combo box. Back in form mode, try your combo box out, it should work. I'm not sure if all your records will be automatically updated, you may have to go form by form and re-enter the combobox.
I am assuming you know how to create an inner join query & of course, you've already created a relationship between your two tables.
Write back if this is not the case or you need any other assistance (haven't explained myself well).
Good Luck!