concatenating related records into single field

[climbd]

I'm not sure if this is best handled by a portal, or other means, but I'll describe what I have and want to do...

I have a one to many relationship between two tables.

The "many" relationship is a list of options... so to be really simple we'll say I have 3 related records giving different color options...

Red.

Blue

Yellow

Now, instead of having them listed in three different portal rows, I would like them concatenated to read:

"Red OR Blue OR Yellow"

These color options are really simplified, for the example, they could be full sentences. In MySQL, the equivalent would be GROUP_CONCAT...

Any advice would be appreciated Thanks!

[comment]

Try a calculation field (in the parent table) =

Substitute ( List ( Colors::Color ) ; ¶ ; " OR " )

[climbd]

Cool, Thanks!