May 22, 20178 yr 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
May 22, 20178 yr 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, 20178 yr by comment
Create an account or sign in to comment