How do I lookup a value from another table and insert in my form?

R

rcfuller

I want to be able to have Access look at a soils table and based on the soil
type I select in a combo box, go to that table and select the limitations for
urban development specific to that soil type...and then place it in the main
report.
 
M

[MVP] S.Clark

Examine the Orders form in the Northwind database example. They lookup the
price based on the product.
 
J

John Vinson

I want to be able to have Access look at a soils table and based on the soil
type I select in a combo box, go to that table and select the limitations for
urban development specific to that soil type...and then place it in the main
report.
Click to expand...

Create a Query joining the Soils table to the table upon which you're
basing the Report, and choose the desired field or fields from the
soils table.

John W. Vinson[MVP]
 
Top