I have 2 tables (“Liquor” and “Transactions”).
The table “Liquor” has 2 fields namely “TypeLiquor” and “Cost”.
The table “Transactions” has 2 fields (namely “Liquor” and “Price”).
Using a Combo Box on a Form I wish to search table “Liquor” and put BOTH the “TypeLiquor” and the “Cost” into the fields “Liquor” and “Price” in the Table "Transactions".
I am having problems placing both fields simultaneously.