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?