AutoLookup

[Ginger]

I have a table called Quotes from which I also created a
form. The form is based on a query that is designed to
auto look up data from a field in the Customers table and
automatically fill in data of the same fields in the
Quotes form. This is working fine, however, the data
that automatically fills in like fields on the form does
not appear in the Quotes table. Any idea how I can get
the fields in the table to include the auto look up data
also?

Thanks,
Ginger

 

[Duane Hookom]

All you should need in the quotes table is the primary key value from the
Customers table. Is there a particular reason you think you need to store
additional values from the Customers table in the Quotes table?