Lookup from Table

[dmc456]

I'm building my first useful data base and need some help auto fillin
my table based on the Lookup function. Please help me with thi
example.

I have a table with customers "Customer Info"; columns are: cust ID
First Name, Last Name.

I have a table with quoted services "Quotes"; columns are: cust ID
Service, Price.

I need to make a table for my service records based on customer IDs.
The table should have the following columns: cust ID, Service, Price.

In the table I need to make, "Service" should be pulled from tabl
"Quotes" based on a lookup from the cust ID in the current table.
"Price" should be pulled from "Quotes" table based on "Cust ID" an
"Service" selected in the current table.

Please let me know what I'm doing wrong. I can get the prope
relations to work. I can get the cust IDs and the quotes to wor
together, but I can't get the 3rd table to work with the first tw
tables.

Thanks

Davi

 

[dmc456]

Still looking for help on addressing my problem