I am using SharePoint 2010 and would like to display information from a Site Pages library and a Documents library based upon an identical field name that is contained in both libraries. My thought was to tie the information together based upon this one field and create a view. I have tried a Content Query WebPart, but cannot figure out how to connect information from each library into one view.
Is this possible to do this? If so, what approach should I start with? Even though I am a developer to this particular SharePoint site, the farm administrators have disabled the use of SharePoint Designer. So I cannot use that tool as a resource.
Any help would be appreciated.