Connecting a column in one table to another column in another tabl

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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?
Click to expand...

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.
 
Back
Top