11 Replies Latest reply on Oct 21, 2013 9:20 AM by rsantana

    Iterate through related child table, and merge values into single field within parent table

    EricLevine

      Title

      Iterate through related child table, and merge values into single field within parent table

      Post

           Hi all... While experienced with SQL and relational databases, new to FileMaker.  I am trying to perform the following task.  I have two tables, for the purposes of this question I will call them Parent table and Child table with a one-to-many relationship.  I have a field in the Child table, we will call it Field.  What I am trying to do is iterate through Child table related to Parent, grabbing the value in Field and populating the data into a new field called NewField that will contain the following values separated by a front slash.

           Value1 / Value 2 / Value 3 / ...

           Any help you all can lend is much appreciated.