Custom Layout Views for a Record with relationship details

Question

Is it possible to create custom views for a particular record that will include details on related fields?

For example, I have a Student object and a Course object, and then I have a StudentCourseRelationship object that represents a Student having a relationship with a Course. This Relationship Object has some fields like completed which is a boolean.

With this data, I would like to create a view related to the student that would display:

• Student Information (all my custom fields)
• A list of the student's StudentCourseRelationships where completed==true
• A list of the student's StudentCourseRelationships where completed==false

In simpler terms, StudentCourseRelationship is suppose to represent any Course a Student has enrolled in at one point or another, and in the Student View, I want to display both a list of the student's completed courses and a list of the student's incomplete courses.

Is this possible? Everything I research related to custom views leads to a custom object's Page Layout (single record) or creating a custom List View (single object).

EDIT: A more complicated example of where I will need to use such a Layout View:

I have an Advisor object. I have a Student object that has a Gender look up field and an Advisor look up field. I have a Match field that has look up fields to Student and Career.

Advisor --> Student Gender --> Student Student --> Match <-- Career

How could I create a view/report that, for a single Advisor Record would show me:

How many times each `Career` record has been "Matched" to a `Student`, broken down by the student's gender?

i.e. 
Accounting: 10 Matches to Male Students, 30 Matches to Female Students
IT: 30 Matches to Female Students, 10 Matches to Male Students

Is the only possible way to do this through a Visual Force page? Could this be done through Reports (grouped reports don't seem to work as I originally expected)?

Answer 1

From comments:

My whole question was whether or not this is possible... so VisualForce pages are my answer?

This is possible, but using some customization. At times when we exhaust the options what are available to us out of the box, we could utilize the customization route.

In your case, you can either utilize the configuration only route if you are only looking for a filtered list view as mentioned in Filter Related Lists without Code by @Doug Ayers.

OR

If you don't want to utilize the option as in the link, your options depending on the view you are in Classic vs. Lightning, are to create custom screens using:

• Visualforce pages
• Lightning Aura Component
• Lightning Web Component