AnsweredAssumed Answered

Pop-up field of names from same table

Question asked by notJames on Jul 28, 2014
Latest reply on Jul 28, 2014 by nihmbrisby


Pop-up field of names from same table


     I have a table of students with two billing designations: primary and secondary (pop up field that lets you choose between the two). I would like to add a pop-up or drop-down field to that table that lists all the students with the "primary" designation.

     Will this involve a self-join relationship? Or creating another table that automatically adds records based on what students are designated as "primary"?