Calculated Cross-site lookup

Question

Hi,

I have 2 sites. SiteA and SiteB.
SiteA has a list called ListA with 3 columns(FirstName, LastName and email address).
SiteB has 5 columns (FirstName, LastName, email address, Project Name and Project Status)

When I want to enter FirstName in ListB, I want this information to be looked-up in ListA and auto-fill/auto-populate LastName and Email Address in ListB by doing a lookup in ListA.

How may I do this calculated cross-site lookup?

It is not possible OOTB so I am happy to purchase a tool.

Thank you

Answer 1

Hi,

This feature will be available in SharePoint 2010, but I assume you need it now. It is not so hard to create a solution for that and that is one of the "projects" I'm just working on in my spare time. It is built on a custom lookup field type. What time frame do you need that? Immediately or it is OK to wait a few weeks?

If it is urgent for you you can create it yourself. The most important part is to create the read-only lookup field type that get their lookup properties (site, list and item ID) from the "master" lookup field.

Peter

Answer 2

Thank you for your answer. I have just found a 3rd party tool which meets my requirements. I do not know if I am allowed to write the name of the product here.
Good to hear that this feature will be available in SharePoint 2010.

Answer 3

Hi,

Thanks for your feedback. Yes, I think you can write the name of the tool here. I think that would be pretty useful for us all.

Peter

Answer 4

Hi,

It is Cascaded Lookup tool from Sharepointboost 
http://www.sharepointboost.com/cascaded-lookup.html

Regards

Answer 5

Hi,

Just want to ask how could I create a custom code for the cross-site lookup using sharepoint 2010, my Objective are the following:

• In SiteA List1 and SiteB List2 I need to associate a column for my lookup?
• In SiteA List1 I need to associate to two or more sites?
• In SiteA List1 or SiteB List2 I could add new columns to each site and It will reflect to the associated (e.g. SiteA list1 (column: Field1) > SiteB list2 (column:Field2) ) list?

Thank you in advance.