Calculations affecting Date Modified Field
Using FMP 10 (along with Server 9), the first user to open a database containing calculations (mostly date calculations, if that matters), renders all records in the database as modified by that user. Is there any workaround for this? I noticed that using FM 9 I had the same problem.
Any advice is much appreciated.
Thank you for your post.
Whenever data is modified in a record, it is updated in any Modified Date fields and Modified User fields. This is as designed.
You could create an additional table, so that whenever the Modified Date field is changed, that record is written to another database table. You would then have a running record.