I have to figure out a way to update multiple rows of data based on another rows of data within the same table.
We will have several rows of data then a row will be added to id the SchoolCode needed for all the data above. A column called U_Configuration will link the SchoolCode to the multiple rows.
I have included a sample order to show how the data is used and to better help assist with the update command.
I am having trouble getting any type of update to look at the SchoolCode and then update all the data where U_Configuration is the same.
What is getting me the most is insuring that the update affects the rows that DocEntry is equal to DocEntry, if have several orders that have the same configurations but the update needs to look at the doc number or docentry then continue to Loop through each line and order seperatly.
I hope someone can help this is a major need Data.xlsx