Data Sources

[Guest]

I want the source of a field to be a list of sources in the field of one
table, but once I select that source, I want it to populate the value of a
field in a different table. How is this done?

Say for example, I have a field named customer. I want a drop down to list
all of the customers from my customer field of a specific table. but when I
select the customer I want it to populate the field of a different table.

I don't know if the control source is one of these and the row source the
other, but that would make sense.

 

[[MVP] S.Clark]

If this is a 1-M relationship, then this can be done with a form and
subform.