Pass value between unrelated SharePoint lists

TEEDA
TEEDA used Ask the Experts™
on
List A contains column Names, Password
List B contains column Passwords

I need to grab a value from List B and populate Password field in List A. Then the password in List B should be deleted.

Any advice on the best way to do this? I've tried with a workflow when a new item is created in List A, but I get stuck at this point(see screen shot below)
hd003.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ivan PadabedDirector, Technology Solutions

Commented:
not very clear requirements actually. what Password should we get from the list B - first one? last one? One equivalent to list A password value?

Author

Commented:
Sorry - the password column in List A, which is blank, should grab the first password from List B.  Then that gets deleted in List B so it is not re-used - I can do the deletion with a workflow.  Thanks.
Director, Technology Solutions
Commented:
ok, as e I would prefer fastest and easiest way - Event Receiver, attached to list A and handling event OnItemAdded. I know, there is some codeing required but it's pretty easy.

Author

Commented:
Thanks! This is not something I can do myself, but I do have a colleague that can help out.  

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial