Updating a Single Row from Multiple Records
I am having issues to getting unique values from multiple records from related tables.
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!