Sharepoint: Any way to get lookup list's other column's value?

let's say, I've create 2 splist, one is 'student_course', another is 'st开发者_JAVA技巧udent'. the student_course contains a lookup field "student_id" of student.

is there any way i can display all the student information which is under course of "computer science"?

Thanks in advance for whoever trying to help. =)

In SharePoint 2010 it comes out of the box, it's easier to upgrade then to develop a custom field

In SharePoint 2010 you can just select the other columns from the list from which you are pulling the lookup column. See below...

You are limited in the types of data you can pull in from other columns in the lookup list. Those limitations can be found in this MS SharePoint article and are essentially that you can only pull:

• Single Line of Text
• Number
• Date and Time

All of the other column types cannot be pulled in via a lookup.