I want to built this but I would like to know if it is possible in Zoho Creator:

Let's say there are 3 tables:

- Students (id, name, etc)

- Courses (id, name, etc)

- Enrollments (id, courseid, studentid, etc)

On a detailed student page (coded by myself in my own layout i guess, not a report?) next to all the student details that are in the Students table itself I want to list the enrollments of this student. 

In sql i would just simply query 'select * from enrollments where studentid = x' and then per result i would query the courses table with the enrollmentCourseID to get the course information.

When I created in Enrollment form the lookup field Students I linked it to Students > StudentID. But it seems there is another value stored then the actual StudentID?

In Enrollment making StudentID a Bidirectional Relation doesn't help, then I can have only 1 record with the same student (this should be unlimited of course)

Am I thinking in the wrong direction, should I think different creating this with Zoho Creator?

-----------------student detail page--------------------------------------------

Student Name

Address

Etc

                  Enrollments

                  Course 1      info      info      etc

                  Course 2      info      info      etc      

                  Course 3      info      info      etc

------------------------------------------------------------------------------------------

Of course this is an example and can be applied to many other sorts of information.

Thanks a lot!

Regards,

Peter