Newbies climbd Posted February 13, 2011 Newbies Share Posted February 13, 2011 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! Link to comment Share on other sites More sharing options...
comment Posted February 13, 2011 Share Posted February 13, 2011 Try a calculation field (in the parent table) = Substitute ( List ( Colors::Color ) ; ¶ ; " OR " ) Link to comment Share on other sites More sharing options...
Newbies climbd Posted February 14, 2011 Author Newbies Share Posted February 14, 2011 Cool, Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4832 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now