Modified by User Field

[Joseph31]

Looks like a simple question at first -- but read on.

I have a main page which has about 5 different related pages that connect to it. I wanted to start an auto calc field that show the person who modified the page last and date --- this works well for the main page but ever time someone modifies one of the other related pages the modified date and user does not change --- QUESTION: Is there a way to make it all link together per main page w/ all related pages. So if someone changes something on any related page to the main page it updated the modified date on the main page.

Thank you,

Joseph

[MarkWilson]

Using a Max() funciton on the auto-entered, modification timestamp of all related tables would give you the last modified timestamp. It could also be used in creating the parent table key field to the last modified child record. This would allow the username and any other data to be brought to the parent table.

The parent table must be refreshed to trigger the updated value.

[Joseph31]

Great thank you very helpful.

Joseph

[Joseph31]

Ok I tried what you said can you show me how I can use this to modify the parent record?

Thank you,

Joseph

[MarkWilson]

Joseph,

Thy this sample file.

Update.zip

[Joseph31]

Thank you again --- Really helpful

Joseph