Adding Kids to custom directory

[Zorak]

The m.KIDS variable that we use here is:

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)

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)