Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page