4 Replies Latest reply on Jan 23, 2015 12:58 PM by mikebeargie

    How To Copy Data To One Field From Multiple Portal Records


      I separated a database into two related databases connected by ID number


      Main has ID number, Family name

      Related has ID number, Names in family


      I'd like to list the names as

      Frey, Sarah, Steve, Henry, Gillian


      Instead of (which I could do with a portal)

      Frey, Sarah

      Frey, Steve

      Frey, Henry

      Frey, Gillian


      I see that I might be able to write a script

      Set Field [MainTable;;NewField; List (RelatedTable;;FirstName)]


      but I can't get it to work