AnsweredAssumed Answered

Related Value List

Question asked by DustFairy on Mar 21, 2015
Latest reply on Apr 4, 2015 by DustFairy


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.