Jump to content

Multiple (Self-join) Portals as columns on one page


This topic is 5770 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am new to this forum and if I have missed the solution to this issue in my search, I apologize. If you can point me to an existing reply which might help me or if you have ANY input, I would greatly appreciate it!


I am trying to create a one page report showing 6 different columns of student names by classroom number. I have a student table(with studentID), a classes table(with class no.) and a students by class table(with both studentID and class no.). I created the appropriate relationships among the tables and self-joins by classroom number within the studentsbyclass table. (Maybe self-joins are not the route I should take??)

My problem is: If I place the portals in the classes table, only one portal or classroom will show related students. If I place the portals in the studentsbyclass table, only the related students for a class show up if you are in a particular record.

How can I make the portals show all related students by classroom number globally, no matter which record you are in and where/how can I place each portal as a column of data next to one another on a single report page?

Thanks for any hep I may receive!!

Link to comment
Share on other sites

The selfjoin is allright but the realtion should be carthesian, but it seems line you could need some of the funtionality found in this template?


Which means a relations def (perhaps 2) for each field type to group by!


Link to comment
Share on other sites

If you want 6 columns of 6 classes, you will need 6 portals and 12 relationships* - and 6 ClassID fields to establish those relationships. It doesn't matter in which table those 6 fields are. I would make a special Viewer table just for this, and build those relationship in a separate TOG.


(*) It's 12 relationships, because you need a pair for each column:

Viewer::gClassID1 = Enrollments1::ClassID

Enrollments1::StudentID = Students1::StudentID

Link to comment
Share on other sites

This topic is 5770 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.