AnsweredAssumed Answered

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

Question asked by EricLevine on Oct 19, 2013
Latest reply on Oct 21, 2013 by rsantana

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.

Outcomes