AnsweredAssumed Answered

display related records in one field

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


display related records in one field


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