1 Reply Latest reply on Oct 21, 2014 2:00 PM by briancrockett

    calculation to combine related text records



      calculation to combine related text records


      Sorry for my inexperience, I imagine this is a simple problem that's been answered before, but I've searched without luck...

      I'd like to create a field which combines related text records.  The particular use I'm trying to make work is:

      Three book titles may be on the same contract.  I display all three in a portal, of course, but would like to create a "contract title" field which displays all three titles in one field.  For example:

      Record 1: A Song of Ice and Fire

      Record 2: A Clash of Kings

      Record 3: A Storm of Swords

      ...would display as:

      Contract Title: "A Song of Ice and Fire, A Clash of Kings, A Storm of Swords"

      Thanks for any help,