Here’s another common SharePoint Designer workflow question:
"Can I access (read/write) SharePoint lists via workflows which do not reside on the same site as the list itself?"
The simple answer is: No.
As in so many ways, however, we have to qualify that (which is a good thing in this case). The platform lets us create extensions to the produce in many ways, including a custom action (see my little codeplex project here for an example). A custom action lets us do basically anything we want from SharePoint designer workflow. I’m a big fan of this, in fact, since it gives us the best of both worlds — a declarative end-user friendly designer with the full depth of the .NET framework at our finger tips.
Sadly, if you’re using SPD, there’s a good chance you’re doing that because you can’t use visual studio (due to the fact that visual studio requires a deep developer background). I don’t have any good answer to that problem except that you should prevail upon one of your technical co-workers to create the kind of custom action you need. Alternatively, work with management to hire or contract that kind of resource.
Follow me on Twitter at http://www.twitter.com/pagalvin