I have a Projects grid and a Tasks grid.
The Projects grid has fields for Project name, start date, and end date.
The Tasks grid has fields for Task name, start date, end date, and reference to the Project name.
For each Project, I would like the start date to be the earliest Task start date among all the Tasks that reference that Project.
Similarly, I would like the end date of each Project to be the latest Task end date among all the Tasks that reference that Project.
Thank you in advance for any help!!