1 Reply Latest reply on Jan 20, 2009 1:44 PM by TSGal

    Calculations affecting Date Modified Field

    LWH777

      Title

      Calculations affecting Date Modified Field

      Post

      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. 

       

       - Mark

        • 1. Re: Calculations affecting Date Modified Field
          TSGal

          LWH777:

           

          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.

           

          TSGal

          FileMaker, Inc.