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

    display related records in one field



      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