View Full Version : combine one-to-many records into text string


03-09-2005, 11:26 AM
One customer can have many products. The database is one-to-many. Is there a function (expression) that would combine all products for a customer in a single text string.


Stan Mathews
03-09-2005, 12:20 PM
Please define "all products". Do you mean all of the fields for all of their product records or do you just want, say, all descriptions?

Look at table.external_record_content_get() for concatenation of text values across records.

03-09-2005, 12:53 PM
All descriptions.

Can't find the function you are referring too.

Jim Chapman
03-09-2005, 01:24 PM
Hello Jack,

As Stan said, the table.external_record_content_get() is the function you want. A description is found in the Alpha Help file, either download a current version or go it it online in the learning center of Alpha Web Site.

Good luck,