2 Replies Latest reply on Sep 14, 2016 6:33 PM by beverly

    Breaking Repeating Fields in to a related record





      I have a very old FM solution called "Clients" that uses 10 repetitions of each repeating fields to list payments for each record.



      ie.       DateRepeatingField1            CheckRepeatingField1             AmountRepeatingField1

                 DateRepeatingField2            CheckRepeatingField2             AmountRepeatingField2         

                 DateRepeatingField3            CheckRepeatingField3              AmountRepeatingField3

                 DateRepeatingField4            CheckRepeatingField4              AmountRepeatingField4

                 DateRepeatingField5            CheckRepeatingField5              AmountRepeatingField5

                 DateRepeatingField6            CheckRepeatingField6              AmountRepeatingField6         

                 DateRepeatingField7            CheckRepeatingField7              AmountRepeatingField7

                 DateRepeatingField8            CheckRepeatingField8              AmountRepeatingField8

                 DateRepeatingField9            CheckRepeatingField9              AmountRepeatingField9

                 DateRepeatingField10          CheckRepeatingField10            AmountRepeatingField10         





      The "Clients" solution also contains a Unique ID for each record.



      How do I export the repeating fields, so that each Child record created has Clients::UniqueID  Date1, Check1, Amount1


                                                                               Child record Two has Clients::UniqueID  Date2, Check2, Amount2



                                                                                      ect                             Clients::UniqueID  Date10, Check10, Amount10