title: ACCESS 2013: Trying to update two fields in one table with many from another
body: <p>I have a linked table in Access that I want to update from a local table. The problem is that the linked table is used for specifications so it contains one line for each attribute. For example, the two fields used in the linked table are ATTRIBUTE_DESC and ATTRIBUTE_VALUE. Each specification may have multiple descriptions. Here is a sample from the linked table:</p>
  
  <pre><code>SPECIFICATION_NO    SPEC_SEQ_NO ATTRIBUTE_DESC    ATTRIBUTE_VALUE
  ------------------  ----------- ---------------   -----------------
  0000000001          10          MANUFACTURER      AMERICAN DARLING
  0000000001          15          MODEL             B84B-5
  0000000001          20          YEAR MANUFACTURED 2000
  0000000001          25          DATE INSTALLED    5/3/1999
  0000000001          30          EXTENSION LENGTH    
  0000000001          35          MAIN VALVE SIZE   6
  0000000001          40          ISOLATION VALVE   DIAMETER  
  0000000001          45          ISOLATION VALVE   DIRECTION 
  0000000001          50          ISOLATION VALVE   DISTANCE  
  0000000001          55          AS BUILT #        C025-106-113
  0000000001          60          ENVIRONMENT 
  0000000001          65          STR 
  0000000001          70          FIVE YEAR PM DUE  OCTOBER 2015
  </code></pre>
  
  <p>The local table has different ATTRIBUTE_VALUES based on the ATTRIBUTE_DESC in the linked table. For example, above the MANUFACTURER might be CLOW instead of AMERICAN DARLING.</p>
  
  <p>The query I created has all of the relevant specification information in the table and I've used the ATTRIBUTE_DESC with different criteria to update the ATTRIBUTE_VALUE.</p>
  
  <p>Unfortunately doing it this way I get an error "Duplicate Output Destination "PROD_SA_SPECIFICATION_DETAILS.ATTRIBUTE_VALUE". So my question is whether there is a better way to update this type of table - either through a different query setup or via VBA. I don't know much VBA so if that is the best answer can I get an example for one of the attributes?</p>
  
  <p>Thanks.</p>