Hello Everyone,
I have grown fond of utilizing Microsoft Access 2010 and SharePoint 2010 Enterprise edition to develop fast and effective applications which can be enhanced by Excel’s awesome pivot tables for reporting.
I am aware of the Parent – Child relationship which can be established using lookup fields.
I am trying to understand if it is possible to create a Parent – Child – Grandchild relationship which can be utilized within Access 2010? the Problem I run into is the Grandchild relationship. I need to be able to see all fields in one table to export into Excel. Right now I can not see the grandchildren.
Can some one let me know if this is even possible and if so any suggestions?
Have a look at the following post:
http://sharepointificate.blogspot.in/2012/12/joins-and-projections-in-sharepoint-2010.html
Hope it helps !
