February 13, 201114 yr Newbies 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!
February 13, 201114 yr Try a calculation field (in the parent table) = Substitute ( List ( Colors::Color ) ; ¶ ; " OR " )
Create an account or sign in to comment