currently I'm trying to copy from one list to another. However I have an issue in that the field names are different and can't really change without causing more headaches (example: First Name is FName on the other list) . I'm wondering what have people done to move list items when this is the case. I could always resort to a custom development script but was hoping to avoid this.
One theory I had and wondered if anyone tried is something of a "junction table" that would have 2 fields such as First Name and Fname with Fname being a lookup to First Name. Then do a multi-step copy in the workflow, does this work? Thanks!
This is using MOSS 2007 with SharePoint Designer workflows.