AnsweredAssumed Answered

Updating a Single Row from Multiple Records

Question asked by ZoltanOrban_1 on Apr 30, 2014
Latest reply on May 1, 2014 by ZoltanOrban_1

Title

Updating a Single Row from Multiple Records

Post

     Hello,

      

     I am having issues to getting unique values from multiple records from  related tables.

     Table1:

     item#
     location
     qty

     Table2:

     item#
     qty_at_location1
     qty_at_location2
     qty_at_location3
     qty_at_location4
     qty_at_location5
     totalQty

      

     Relationship:

     Table1:item# = Table2:item#

     My question is: what is the easiest way to get the qty of each location from Table1 to Table2 for the same item to the right column? The total was very easy, but I am only getting the value of the first related record from Table1.

     Thanks for the help! 

      

      

Outcomes