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.
View Complete Post