I have created a "Student" database with the following tables...

Student

Groups

Grouplineitem

See attached picture of layout

Working from the "Student" layout, I want to create a portal on the left side of the layout and have it list all the students names who are in a certain group. For example, if I want to view just the "Band" members, I would have a global field with the name of the group. Once selected, it would then view just the "Band" students.

I have been able to get this relation set up. My problem is I want to click on a students name and have it go to their record in the current layout which is the "Student" layout and table.

I cannot get this to work using the "Go to Related Record". I really need to keep this on the Student's layout using the student's table. Any suggestions?

Thanks,

Sam

There should not be anything wrong with what you are trying.

Are you sure you are going to the related student->selectedgroup->student record, and not the group or the student?

If you try to select the layout you are going to manually, you can see if the student layout pops up in the list. If it dosnt you are using the wrong relation.