Forum Discussion
Paul Hayes
Feb 19, 2020Copper Contributor
How to concatenate multiple records from a linked table into one record and one field in the master
I am most of the way there with an app for references in a document. I can create linked primary author and parent document and have these as fields in the master table. However there are often multiple authors and I can create the records in a linked reference authors table. However I want to produce a field in the reference table, or a view based on the reference table, that concatenates the multiple authors into one field starting with the primary author on whom the reference is based.
I don't know which way to go - can I use the record set for the multiple authors and build a concatenated string with a form to the linked multiple authors table in the app or am I best to build a view using all the linked tables and use a SQL Coalesce function to build the concatenated string in the view? Any suggestions please!
No RepliesBe the first to reply