Results 1 to 2 of 2
  1. #1
    montefortej is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jan 2017
    Posts
    1

    Linking Two Values in an existing Table


    I believe that this is a fairly simple issue. I am looking to compile data from two different sources. Our customer uses one number for product identification (Item Number) and we use an entirely separate number on our end (NAED). I have a table that lists the item number next to each corresponding NAED and would like to link them together for my remaining queries. Each NAED and Item number should only have one match. Any help here would be greatly appreciated.

    Thanks!

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Either create a Junction table (which it sounds like you already have) that is used to link the two table together, or simply store both values in the same table (which you should be able to do if it is a one-to-one join type). You can use an Update Query to update the values in your main table.

    If you elect to store a separate Junction table instead, then every query will need to use both tables and the Junction table.

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

Similar Threads

  1. Replies: 29
    Last Post: 04-25-2014, 03:49 PM
  2. Replies: 11
    Last Post: 07-24-2012, 07:50 PM
  3. Replies: 0
    Last Post: 07-26-2011, 02:03 PM
  4. Replies: 7
    Last Post: 04-15-2011, 08:46 AM
  5. Replies: 1
    Last Post: 05-18-2010, 11:43 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
  •  
Other Forums: Microsoft Office Forums