AnsweredAssumed Answered

display related records in one field

Question asked by AdamReed on May 27, 2012
Latest reply on May 27, 2012 by davidanders

Title

display related records in one field

Post

I have an author table (with author id), a book table (with book id), and a linking table between these which handles the relationship.

Some books have more than one author, and rather than display the multiple authors in a portal (which is fine in some layouts), I'd like to be able to have a field that combines them so my layout looks like:

The Great Gatsby Goes to Georgia, by F. Scott Fitzgerald and William Faulkner

Outcomes