In one of my apps I have a parent child relationship and I would like a field on the parent level that shows the most recent value in one of the child fields for that record.
As an example:
Parent table - Projects
Child table - Meeting Notes
One of the fields in the child table is "Meeting Outcome" which is a multiple-choice type field. This is the field I would like to show in the Projects table.
Example data:
Projects table:
| Record ID | Project Name | Meeting Outcome |
| 1 | Project ABC | Approved |
Meeting Notes table:
| Related Project | Meeting Date | Meeting Outcome |
| 1 | 12/10/2022 | Additional Info Needed |
| 1 | 12/11/2022 | Meeting Rescheduled |
| 1 | 12/13/2022 | Approved |
The last/most up to date value in Meeting Outcome is the value desired in the Projects table so the user can see the outcome of the last meeting.
What is the best method to accomplish this?
------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------
