Jump to content

Self-Join Layout


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

Recommended Posts

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

 

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 2502 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.