Cross-Site Lookups in SharePoint 2010 Enterprise
How to get information from one SharePoint site to another is one of the most common type of questions that I come across. When you have SharePoint 2010 Enterprise or SharePoint Online E3 or E4, most any SharePoint list can be customized using InfoPath. All of your lists and your existing InfoPath forms can look up information from other sites.
Read more