I am trying to pull last names and first names from an output set and am running into a problem. For households, there is no first name and the last name comes out John and Ann Smith Household. I know we've had this problem before and it is the TR_Query_Element set up but I don't remember what the Data From field is supposed to be to fix it, right now it is T_CUSTOMER.
What are you looking for the output to be? Just guessing you're looking for
Lastname = Smith
Firstname = John and Ann
Would that be correct?
Martin