Forum Discussion

Paul Hayes's avatar
Paul Hayes
Copper Contributor
Feb 19, 2020

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

Resources