Sharepoint2010 Lists Lookup

I'm creating 3 lists using Sharepoint 2010 UI. The lists and relationship are as follows: Training (parent)开发者_JS百科 -> 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.

I think it would be much clearer if you guys tried to create the lists in your development machine. I'm using custom list to define the three lists I'm using. I would suggest you to create the following lists:-

Training <-lookup <- Training Instance <- lookup <- Training Session.

All the lists have one similiar field named Training. This field is first created in the training list, the Training Instance is created when a user select which training he wants to held. And because the training instance can have more than one session, the Training session will keep the lists.

You'll see that you can add items to the Training Session just fine, but when you try to insert item for Training Session, you'll find that the training field in this lists which is set to look up the Training Instance is empty.

I hope I made my problem clear. Thanks to all you guys for trying to help me, I really2 apperciate it. Thanks.

---

You cannot do that with SharePoint 2010 OOB. You have to either use Foundation API or REST API to display ALL the three lists info in one list-LIKE format. Using a control like hierarchical grid would be ideal in this scenario.

You should create a separate list for look ups or lists with one to many / many to many relationships.If you have a one to one relationship between your training instance and training session lists then I suggest moving your training session fields to training instance list and make it in ONE list.

EDIT: Look up Field/Column settings should look like this

---

Just as on the other site. There are a lot of ways of doing this.

Web Services is one with SOAP and CAML. The other is SPServices. You will find plenty of examples of both on here and on the web.

Elaborate on which language you are using and maybe include more details so we can help more.

Lists web services - GetListItems

SPServices