I have 2 Lists. List A has a look-up field where multiple values can be selected. I store the ID. Thus the record may look like the below:
ID Title Color Lookup Designer:ID
1 My Idea Blue 55;59
When a new record is created in List A I would then like to update List B with the List A ID. I know a split can be done to extract the 55 and 59, but how do I essentially do a split and loop thru the split values found in the new record from List A and update List B with the List A ID ?
ID List A UID