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 "