I have a Kit table and a child table called Kit and Product Tie. Kit table contains the name and ID of kits, where the Kit and Product Tie contains the products that are in the kits. They are joined by a Kit ID.

 

I have a modification time and date stamp field in the Kit and Product Tie table which shows the user when anything in that specific kit was modified. The field only sometimes updates. Most of the time it doesn't change the date or time from the previous entry. I can't figure out what I'm doing wrong. I've turned indexing on and off, tried adding repetitions(?), tried changing which table the time stamp is created in, set a script to refresh the page and flush the results. Nothing. I don't understand why it only sometimes updates.

 

Any ideas?

what does "repetitions" have to do with your calculation? Are you storing these mod date in a repeating field?

what does "repetitions" have to do with your calculation? Are you storing these mod date in a repeating field?

 

No, I was just running out of ideas trying anything and everything to try and see what was affecting whether the field was updating or not. 

Is your time stamp field an auto-enter or a calculation?

The default modification timestamp option will only record changes to records in the current table. Changes in related tables won't be recorded.