Hi,
I need to get all the contact emails related to the customer from the GI.
When I join the customer and contact table GI is showing like that.
Above customer has 5 contact emails. I need to show all 5 contacts as a list (not 5 rows only 1 row).
ex: 1st email,2nd email,3rd email
How I do that ?
Best answer by dcomerford
View original
+12
I dont believe this is possible using a generic inquiry as each record is its own rpw and you cannot use the Aggregate function for a text field to group by customer. I would write a SQL based View for a DAC and use that in the GI instead
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
