Here is my second tab...
I guess let me rephrase this...
My Information and my notes updates that Modified field. However my Events does not. It is a portal view to another table. The tables are linked, but when I make changes to it, it will not update the modified field on the left.
A field set to auto-enter a modification date will only update with a new date if a field in that record is modified. Modifying data in a related record will not cause it to update.
In the first screenshot, the modification date will automatically update if I change any fields in the records in the Information tab as well as the notes tab. The Events tab as shown in my second screenshot will not update that "modification date" like the others. I am thinking because it is a portal to another database (Sales::Events) vs (Sales::Main). I think what I am needing is to link the table relationships, but not sure which ones and what settings. I tried but it did not work either. Any ideas?
I explained that in my previous post. Your fields on the Events tab are from a related table and changes to a related table are changes in other records. Since no change has taken place in the record where you defined this modification date field, it does not update when one of those fields are edited. Your portal represents a set of multiple records, any one of which might or might not be altered at any given time.
If you want to show a field that changes each time any Related Note record is added, deleted or modified in addition to any modification of the current layout record's fields, you'll need to define a modification date field in the Events table and then add an unstored calculation field that reports the largest (most recent) date from either modification field and over all the related Events table records:
cMostRecentModDate: (define this in your layout's table)
Max ( RecordModifiedDate ; Max ( Events::RecordModifiedDate ) )