I am using the template for contact mgmt to start my database up. In the
contact table there is a field labeled "Last Mtg Date". How can I get the
date on the last record in the Calls table for each client to be placed in
the Last Mtg Date field on the contact table?

jstuntz wrote:
> I am using the template for contact mgmt to start my database up. In
> the contact table there is a field labeled "Last Mtg Date". How can I
> get the date on the last record in the Calls table for each client to
> be placed in the Last Mtg Date field on the contact table?

First you likely should not try. What if you place all that data in the
table, then for one reason or another a date is changed in the other table
or you add a new record to your table?

The usual best practice (unless you don't want updated information) is
to link the two tables using a unique field (we don't really have columns in
a table) in both tables likely a contactID

You can then display the data from table two along with the data from
table one in queries, forms or reports.

If you don't want updated information, then you can do the same thing
except add a new blank field to the first table and make an update query to
update the original table with the data from the second.

--
Joseph Meehan

Dia duit