title: Sharepoint and Cross-Site Lookup
body: <p>I have this scenario</p>
  
  <p>I want to build two sharepoint 2007 sites. One for customers info and the other for products and </p>
  
  <p>customers orders.</p>
  
  <p>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.</p>
  
  <p>I did some search and found custom cross-site fields and used one but when I upgraded the </p>
  
  <p>site to sharepoint 2010 this custom field was not compatible and the upgrade wizard said it could not be upgraded.</p>
  
  <p>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 ?</p>
  
  <p>please if any body has faced such a scenario, share the solution with me ?</p>
  
  <p>thanks</p>