2 Replies Latest reply on Nov 30, 2009 11:19 AM by philmodjunk

    Relationships reverting back to old file

    PAR

      Title

      Relationships reverting back to old file

      Post

      After replacing a file with an updated one of the same name, calculated fields in a related table continue to use the values in the old table. When I open the updated file with the related table open, the old values are there.  When I open it with the related table closed, the new values appear. This began when I upgraded to FMpro10.

        • 1. Re: Relationships reverting back to old file
          littledog
            

          You use FileMaker Server, isn't it?

          Because in FM Pro there is nothing to upload - existing file is opened with FM Pro 10

          • 2. Re: Relationships reverting back to old file
            philmodjunk
              

            I'm guessing that the updated file either has a different filename or is located in a different folder than the original.

             

            Open Manage | External Data Sources...

             

            Search through all the entries here for any that still refer to your original file by name or folder location.

             

            Update them to refer to your new file and the issue should be resolved.

             

            If your solution is now an all in one file solution, you'll probably want to use Manage | Database | Relationships to point each TableOccurrence (Double click each box in question) to the correct table in your new file and then update all scripted references to do the same as well.

             

            FMP advanced's Database Design Report can be very useful for cleaning up old data source references.