I have two forms with a many to many relationship.  I want to create a form that will allow me to view the information from Form A and then show line items from Form B that are related to Form A in one view.  For example:

 

Form A contains:

 

Student First Name

Student Last Name

Student ID

 

Form B contains:

 

Class Name

Class ID

Class Description

 

In a normal relational database I would have a third table that tracked the student's grades, Form C:

 

Form C contains:

 

Student ID

Class ID

Grade

 

Then I would like to vew it as follows:

 

*****************************************************************************************************

Full View

*****************************************************************************************************

Student Info

Student ID                              Student First Name                        Student Last Name

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

Class Name 1                  Grade 1

Class Name 2                  Grade 2

Class Name 3                  Grade 3

 

In another view  (or form) I would be able to list all students and have a link on each one that would take me to this view (or form) too see that student's respective grade.

 

Is this possible in Zoho and how do I accomplish this?

 

Thanks,

 

braqston