Hi all

I have this scenario

I want to build two sharepoint 2007 sites. One for customers info and the other for products and

customers orders.

Now the problem is that in the second site I need to reference the customers info from the first site but unfortunately sharepoint doesnot provide out of the box cross-site lookup.

I did some search and found custom cross-site fields and used one but when I upgraded the

site to sharepoint 2010 this custom field was not compatible and the upgrade wizard said it could not be upgraded.

so what is the solution for this ? is it to merge the two sites so that I can use the standard lookup feature or is there any workaround for this ?

please if any body has faced such a scenario, share the solution with me ?

thanks