Related Value List
I have a parent-child relationship: Unit-------<Inspection.
A Unit gets inspected each year and then is due for inspection one year later.
I have been trying several ways to get the Inspection Due Date field in Unit to update with each new inspection.
I tried a List function to list the inspection dates and then a Right values to select the last date. Thought it worked until I realized all unit due dates were updated to the date of the last unit inspected.
The Inspection record has an auto-fill current date field but if I use that field (as expected) I just get the first record date, when what I want is the last record date.
Does anyone have any suggestions on what I should try?
Thanks in advance.