10 Replies Latest reply on Jun 24, 2016 12:08 PM by tomperr

    Are in table related record calculations possible?


      Within the same table and a found set, is FM capable of looking at the contents of a field in a separate record and returning results through a calculated field?

      EX:  Dates within records will change, but the found set will return 1 of each color, so no conflicts will exist.

      Fields-     Colors       Date                    Calc

                         Red           1/1/16             if( Color =  Red ; Date ; if (color = white ; date ; if (color = blue ; date ;  "")))

                         White         2/1/16                    "

                          Blue          3/1/16                    "