AnsweredAssumed Answered

Primary/Secondary Membership Pop-up

Question asked by notJames on Jun 4, 2014
Latest reply on Jun 4, 2014 by philmodjunk


Primary/Secondary Membership Pop-up


     I have a table of students that have two billing designations: primary and secondary. If two or more students from the same family join the school, the second student is billed under the first (primary) student's membership. I have a pop-up field for these two designations (1= primary, 2= secondary) based on a value list from another table. I want to create another pop-up field such that if the billing designation is "secondary", this new field will only list the primary students, and by their full name and/or Student ID. (I have a "FullName"  field defined by this calculation: First Name & " " & Last Name)