Results 1 to 2 of 2

Thread: Append Query

  1. #1
    Join Date
    Oct 2016

    Exclamation Unanswered: Append Query

    As per the File attached , I want to run Append Query to Append "TRNS" Table from Item_Mast! item_Code ,Item_Mast! item_Code, Cat_Mast!cat_Code , Outlet_Mast!Outlet_Code.

    But outlet_mast!Outlet_code is in RELATIONSHIP with TRNS table and i wish to am inserting data in TRNS table.

    and item_Code , cat_Code , Outlet_Code are key fields in TRNS table.

    Pls suggest me ?
    Attached Thumbnails Attached Thumbnails 1.JPG   2.JPG  

  2. #2
    Join Date
    Apr 2014
    Provided Answers: 34
    You can only add if a master key exists in the Master table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts