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

    How To Copy Data To One Field From Multiple Portal Records

    ftprntz

      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

      Thanks