1 Reply Latest reply on Sep 29, 2011 10:28 AM by philmodjunk

    Duplicated records when opening FM7 file in FM11

    AdamCornwell

      Title

      Duplicated records when opening FM7 file in FM11

      Post

      Hello,

       

      We've been moving newer systems to Filemaker Pro 11 as needed, and while it doesn't seem like there have been many issues, one did come up recently. We have a database (single file) which was put together in Filemaker Pro 7, which when opened in Filemaker Pro 11, appears to have duplicate records for all records in some tables. In particular, it appears that they are all there in triplicate, and the duplicates seem to represent previous data- the latest 'version' of the record is there, along with two previous 'versions' as the result of prior modifications. The same file, when opened in Filemaker Pro 7, does not display these duplicate records.

      Since FMP7 and 11 share the same file format, this seems mysterious, and I have not found any real reason for why this should be occuring. Does anyone have any experience with this, or better yet- solutions?

       

        • 1. Re: Duplicated records when opening FM7 file in FM11
          philmodjunk

          I suggest the following checks to confirm what you are seeing:

          Open the file in 7. Select a layout to this table. (Make sure that Show Records From in this table lists an occurrence of this table). In the status area note the total number of records.

          OPen the file in 11 and repeat these steps. Do you see the same total number of records? If so then you aren't getting any record duplication, but for some reason, the same layout is displaying the records differently with the two system. If that's the case you'll need to describe the design of your layout in greater detail here. Perhaps these are records displayed in a portal?