give back oldest date

Discussion created by gilo on Sep 30, 2015
Latest reply on Oct 1, 2015 by erolst



I have 2 tables, clients and rdv


I use a layout based on clients, where a portal shows me all the rdv (meetings) for this client.


I would like to create a kind of reminder, so I see, and I can make FM show me, when the next meeting should be planed. (+6 months)


How can this be done? I need FM to set the field clients_nextmeeting to rdv_date + 186. This works if I have 1 meeting, but how to tell FM to take the latest date of all meetings and to add 6 month? Has anyone an idea on how to proceed?