Posted: Thu Jun 07, 2007 9:33 am
The m.KIDS variable that we use here is:
What this does, is prints a list of kids, separated by commas, and only includes the kid's last name if it is different from the family last name.
Fields that are required to be in your output fields for this to work:
Directory Sequence (pers_no)
Family Last Name (lastname_a)
Profile Last Name (lastname_b)
Family First Name (firstname_a)
Profile First Name (firstname_b)
Code: Select all
IIF(PERS_NO > 2, IIF(NOT EMPTY(m.KIDS), m.KIDS + ", ","") + ALLTRIM(FIRSTNAME_B) + IIF(LASTNAME_A<>LASTNAME_B,+" "+ALLTRIM(LASTNAME_B),""),m.KIDS)Fields that are required to be in your output fields for this to work:
Directory Sequence (pers_no)
Family Last Name (lastname_a)
Profile Last Name (lastname_b)
Family First Name (firstname_a)
Profile First Name (firstname_b)