Hi,
What I would like to do is simple :
When I update a record in table "Participations", I want to check if this record is the earliest (in term of date) record linked to a specific company. If it is, in single select field "Participation active?" select automatically value "active".
How would you do that? I have trouble adding the condition of selecting the record with the earliest date among records linked to the same company.
Thank you,
Have a nice day,
Arthur