So I ran into a situation where I have two lists containing the same information but in different languages (don't ask me why they chose to do it this way).
Each item links through a workflow-created field to the corresponding item in the other list.
Has a link to:
So it links to the ID (index) of the item.
This means, that the guys responsible for the data has to make sure each item is in the same order. However, they already messed up, and deleted the messed up entries. Sharepoint doesn't automatically continue from the former index though, but apparently just keeps going with an internal index I guess, so now there's a gap in indexes, making the lists 'unmatched'.
That is, the elements at ID 1825 and above doesn't match the elements in the other list.
Anyone have any idea of how to "normalize" the ID's or maybe bulk-modyfing the existing elements, and then making sure, the list continues at the same IDs?
I appreciate any and all pointers at this point.