I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent) -> Training Instance (child, look up Training ) -> Training Session (grandchild,lookup Training Instance)
The problem is when I try to look up the Training Instance from the Training Session list, the Training(look up field) is not visible. All other fields except for the lookup field in the Training Instance lists is visible in the Training Session.
Is it not possible to go beyond child list. Is there any way that I could achieve the same thing (parent -> child -> grandchild).
Any help is very much apperciated. Thanks.