Title
Modification Timestamp - Update to Child Reflected in Parent Timestamp
Post
Howdy Howdy,
I'm thinking this has to be a simple solution, but I can't seem to locate one. What is the cleanest way to have the timestamp on a parent record update when there is an addition/change to a related child?
For example, let's take a contact management database. The parent table has the list of individual names, the related table contains addresses. If I add a related record to the address table I want the timestamp on the parent table (individual names) to reflect this addition.
Thanks in advance,
Dave
Filemaker 10 Pro Advanced
Mac OS 10.6
Windows XP Pro
Yes but from a data integrity standpoint, the modification date should not be altered. Instead use a calculation to display what the last overall modification would be:
Max ( Parent::ModificationDate; Max ( Child::ModificationDate ) )