Iterate through related child table, and merge values into single field within parent table
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.