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

Question

Hi~

let's say, I've create 2 splist, one is 'student_course', another is 'student'. 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. =)

Answer 1

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