Using two tables to append to another table - Help!

Discussion in 'Microsoft Access Database Table Design' started by Antell, Jun 1, 2004.

  1. Antell

    Antell Guest

    I'm using two unrelated tables to append another table.
    Each time I run the query, it adds the correct
    information, but does it twice.

    Table1: Employee ID, and other employee info
    Table 2: Survey code, and other survey into
    to append to
    Table 3:

    Table 1 and 2 do not have a "join".
     
    Antell, Jun 1, 2004
    #1
    1. Advertisements

  2. Antell

    Dwayne Shrum Guest

    It sounds like you really want to do this in two steps
    which means table 1 will do the append (meaning to add new
    records to table 3), then do a seperate update query
    (meaning to change the fields that were not previously set
    with the new information from table 2).

    For example: Insert new record for employee with all the
    table 3 defined fields - using data from table 1.

    Then, modify that same record (only fields that pertain to
    table 2) with table 2 data.

    So the two steps are completely different query modes -
    insert vs update.


    >-----Original Message-----
    >I'm using two unrelated tables to append another table.
    >Each time I run the query, it adds the correct
    >information, but does it twice.
    >
    >Table1: Employee ID, and other employee info
    >Table 2: Survey code, and other survey into
    >to append to
    >Table 3:
    >
    >Table 1 and 2 do not have a "join".
    >.
    >
     
    Dwayne Shrum, Jun 1, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Eliphalet

    Resetting Autonumber during Make Table/Append Table

    Eliphalet, Oct 15, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    250
    Tim Ferguson
    Oct 15, 2003
  2. Eddie

    Append Queries and Tables

    Eddie, Jun 8, 2004, in forum: Microsoft Access Database Table Design
    Replies:
    1
    Views:
    166
    Jeff Boyce
    Jun 9, 2004
  3. BruceM

    Append from main table to related table

    BruceM, Jun 23, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    172
    BruceM
    Jun 26, 2006
  4. Guest

    Records will not append to another table due to Key violations and

    Guest, Jul 13, 2006, in forum: Microsoft Access Database Table Design
    Replies:
    22
    Views:
    889
    Guest
    Jul 19, 2006
  5. MJ

    Make Table v. Append to Table: Need Some Expert Design Inputs

    MJ, Apr 13, 2010, in forum: Microsoft Access Database Table Design
    Replies:
    7
    Views:
    2,628
    John W. Vinson
    Apr 13, 2010
Loading...

Share This Page