2 Replies Latest reply on May 27, 2012 12:05 PM by davidanders

    display related records in one field

    AdamReed

      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