I'm new to this forum, so please forgive me if i've missed something in this post. I've been trying to find an answer to this for a while now, one of those head scratchers that google and forum searching doesn't seem to clarify. I'm new to SharePoint so that probably explains alot also.
I have a list (List A) which has a few lookup columns which fetch information from other lists on the same site. Quite straight forward, except I'm trying to get a workflow on List A to update these lookup columns with different values when updates are made in other lists. I'm using the action "set field to value", with the field being the lookup column and the value being the new value.
Problem is though that this doesn't work, the value doesn't set. I figure this has something to do with the fact that values in the lookup column are not referenced by value but in fact by some generated index, but I'm not familar enough with SharePoint to understand if this is the case.
Anybody have an idea how to do this?
Thanks in advance.