Self-Join Layout

[crazybake]

In my table Contacts I have two fields:

JustOne: Calculation field with value of 1 - global, result is number
Enrolled: Case(Current Student=1;1;"Pre-Student"=1;1;0), result is number

I created a Self-Join between these two fields: Enrolled Students.
I may not be creating the layout properly. I simply created a new layout using records from Enrolled Students, but all records are showing, not just Enrolled=1. I seem to be missing a step

 

[bruceR]

Not missing a step; missing a concept.

You cannot do what you want.

[comment]

Layouts show found sets, not related sets (we have portals to do that). The simple way to show the enrolled students is to find them. Or use the Go to Related Record [] script step to create a found set of related records only.

Note that you do not need have a dedicated layout for the "other" occurrence of the Contacts table; you can reuse an existing layout of the "main" occurrence.

 

 

Edited May 22, 2017 by comment