Using a Combo Box to place 2 fields simultaneously.

[Tom Evans]

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.

[pbaldy]

The second option may be appropriate for you:

http://www.baldyweb.com/Autofill.htm

[Welshgasman]

Don't you mean 'fields “Liquor” and “Price” in the Table "Transactions".
Whilst the cost may change, is the Type going to? That would be the only reason I can see for storing the same data twice, bit like an order item line.?

[mike60smart]

Hi Tom
How are your 2 tables related? What is the Autonumber PrimaryField name in table "Liquor"
What is the related ForeignKey name is table "Transactions"

[Tom Evans]

Don't you mean 'fields “Liquor” and “Price” in the Table "Transactions".
Whilst the cost may change, is the Type going to? That would be the only reason I can see for storing the same data twice, bit like an order item line.?

My error. You are correct - it should be table "Transactions".

[Tom Evans]

Hi Mike. There are other tables and fields in the database. Relationships and Foreign Key Constraints seem to be correct but may need some fine tuning as development progresses.

[Tom Evans]

Thanks Paul. I will try your options later today. I will update you.

[Tom Evans]

This has solved my problem.
Much appreciated.

[mike60smart]

Hi Tom

I would suggest that your table "Liquor” should also have a PK Autonumber of LiquorID

[Tom Evans]

Thanks Mike. Done already. Will get back to you if I have any further problems.
Cheers