Results 1 to 3 of 3
  1. #1
    sud2017 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2017

    Append Query to copy record from 2 tables to 1 table?

    Hi Guys,

    Wondering if its possible to use Append Query to Copy records from 2 tables to 1 table, if yes then is it advisable to do so in the situation explained below?

    Main Form (Quote) - fields are QuoteID, QuoteNo, Quote Desc etc.
    Subform (Item Details) - I have copied item details from another table using Append Query, and this is where I want to copy QuoteID as well from main form to enable searching item records through QuoteNo

    I haven't linked my main form and subform as it was affecting my Append Query process due to some reason.

    Any possible help would be greatly appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Why do you need to copy data from another table? Why duplicating data between tables? Linked main and sub forms should not prevent append query. Would need to know more about your data structure, form/subform design, and the append query you attempted.
    Last edited by June7; 09-14-2017 at 06:47 PM.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    sud2017 is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2017
    Thanks June7. I will try again with Linked Main/Subform and seek your help if I still have an issue.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 04-21-2017, 01:15 PM
  2. Replies: 2
    Last Post: 02-23-2016, 04:36 PM
  3. Replies: 4
    Last Post: 01-20-2015, 12:55 PM
  4. Copy Record data into Two Tables
    By BShick5088 in forum Programming
    Replies: 3
    Last Post: 05-10-2013, 03:02 PM
  5. copy and append a record
    By erikl1 in forum Access
    Replies: 4
    Last Post: 03-02-2012, 03:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums