Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

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

Discussion in 'Information Technology' started by jstuntz, Jul 28, 2006.

  1. jstuntz

    jstuntz
    Expand Collapse
    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?
     
  2. Loading...

    Similar Threads Forum Date
    Need Help - Connecting with the Guru... Questions and Answers Mar 19, 2013
    Buddhism The Zen Brain: Connecting Meditation and Neuroscience Interfaith Dialogues Sep 19, 2011
    Sufism Sufism: Connecting Mankind Interfaith Dialogues Feb 16, 2011
    SikhRI Connecting with the Divine Light Sikh Organisations Jul 23, 2009
    Connecting The Dots In History Essays on Sikhism Mar 21, 2009

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    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
     

Share This Page