This also does not work in FileMaker starter solution Invoices.fmp12
Does anyone have any solution?
(modification timestamp does not change).
The modification timestamp does not change because the record was not modified. You could use =
Max ( LastModified ; Max ( LineItems::LastModified ) )
to return the latest modification timestamp of an invoice and/or its line items.
thanks for suggestion but it does not work.
Define "does not work".
Field on base table does not recalculate after changes being made in related table(records). In other words Auto-enter field on base table does not recalculate based on changes in related table.
You can download sample file here: https://www.dropbox.com/s/yh08rdgit75c1xc/Test_Max_Modified.fmp12
As you can see thet Auto-Enter Log does not update as it should. We can not use script triggers on fields.
I did not suggest an auto-entered calculation. That indeed will not work.
You didn't mention script triggers before. If you want a script to run when either parent or child record were modified, you will have to attach the script trigger to both.
Did you ever get this to work?
Might I ask what method you used?
I have exactly the same dilemma.
We did not because only solution which is suitable for our solution is a script trigger which is triggered automaticly by change in primary table summary field.
Thank you for the response.