I'm making a mail list that contains both Household and Individual records. Development want to be able to sort the list alphabetically. But sorting by last name doesn't work because the first letter of household is somebody's first name . For example, the Steven and Liza Hanks Household will sort as "S" and not as "H."
I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me.
Any suggestions?
Unknown said: I see that the constituent records have a "Sort Name" field. I tried running the list through and Output Set , but I can't find "Sort Name" as an option in Output Set Builder. Maybe it's right in front of me.
It doesn't appear to be available by default, but you could add it, e.g. open the system table TR_QUERY_ELEMENT, add a new row, give it a name in the description column, choose 'Constituent' for the category, enter "!.sort_name" (without the quotes) as the data select, enter "t_customer" as the data select, and save.