Creating a separate field to show the most current Date in a table of Notes
In FM Pro 11, I'm trying to find the right "calculation" to use on a field "MostCurrentAccurateDate."
I have a table of Notes. It includes 3 date fields:
1) "DateNoteCreated," an auto-entered field;
2) "DateActuallyOccurred" field -- where the user can enter a more appropriate date if needed (e.g., notes about a conversation that was actually held on May 3rd, as opposed to the date in #1 above, which would be the date the user actually gets around to creating that note in the database, say May 15th); and
3) "DateMostAccurate" -- a calculated field (result=Date) that gives me the value of #2 unless it's empty, in which case it defaults to give me #1.
I want to create one more field -- that could be shown on other layouts (in related tables) -- that will show me the date of "the most recent" note, based on #3 above (the "dateMostAccurate"). How do I accomplish this??