Welcome to SPN

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

Sign Up Now!

Access: I need to enter a name in one table & it show in another.

Discussion in 'Information Technology' started by kkrhett, Nov 18, 2005.

  1. kkrhett

    kkrhett
    Expand Collapse
    Guest

    I have a database that tracks prospective clients. I have one table that
    keeps up with contact information and another table that tracks our
    correspondence.

    How do I set up access so when I enter a name in the contact info table, the
    name also automatically shows up in the correspondence table?
     
  2. Loading...


  3. Dean

    Dean
    Expand Collapse
    Guest

    You need to add a Client ID field to the correspondence table and define a
    relationship between the tables. This will allow you to have 1 Client with
    many pieces of correspondence. Take a look at the Contact Management sample
    database template the comes with access. You may be able to use it directly
    or with slight modifications.

    "kkrhett" <kkrhett@discussions.microsoft.com> wrote in message
    news:41B880CA-697E-4655-97B6-974484A99B75@microsoft.com...
    >I have a database that tracks prospective clients. I have one table that
    > keeps up with contact information and another table that tracks our
    > correspondence.
    >
    > How do I set up access so when I enter a name in the contact info table,
    > the
    > name also automatically shows up in the correspondence table?
     
  4. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Kkrhett,

    I would imagine that for each Contact, there can/will be more than one
    Correspondence record. This means there is a one-to-many relationship
    between Contacts and Correspondence. I would suggest using something
    other than the client's name as the basis of this relationship, as names
    are not guaranteed to be unique. Probably you need a ClientID or some
    such as the primary key field in the Contacts table, and similarly a
    ClientID field in the Correspondence table to define which Contact each
    Correspondence record relates to. It is best not to use tables for data
    entry. They are for storage. Forms are for data entry/edit/viewing. I
    guess the standard approach to this scenario would be a form based on
    the Contacts table, and a continuous view form based on the
    Correspondence table, and this Correspondence form placed on the
    Contacts form as a subform. The subform's LinkMasterFields and
    LinkChildFields properties are set to ContactID (or your equivalent), so
    any Correspondence entered will then automatically be identified as with
    the current Contact. Hope that makes sense.

    --
    Steve Schapel, Microsoft Access MVP


    kkrhett wrote:
    > I have a database that tracks prospective clients. I have one table that
    > keeps up with contact information and another table that tracks our
    > correspondence.
    >
    > How do I set up access so when I enter a name in the contact info table, the
    > name also automatically shows up in the correspondence table?
     

Share This Page