How do I extract multiple fields when using a combo box?

[Roy33]

Here's the problem -- any help is greatly appreciated!!

For example,
I have one table that has the products:

ID Name Cost
1 Toy $1
2 Game $5

I have a second table with customers in it. There are fields in the customer table that have bio information, but other fields, ID NAME and Cost that exactly match those from the products table.

I have a combo box whereby I can click the ID or Name or Cost field from the customer table(form) and bring up the data from the corresponding field in the products table.

Here's the question:
Is there a way for me to click on the ID field in the customer table, and have the program fill in the other appropriate field. Thus, instead of clicking on all three ID, Name, Cost to fill in the info, I can click on ONE of these fields in the customer table, and the other fields will fill in automatically.

Again, I hope this isn't too trivial and that I've explained myself ok. Thanks in advance for any help.

-Roy33