1 Reply Latest reply on Dec 5, 2012 4:22 PM by philmodjunk

    import question

    dennisseckler

      Summary

      import question

      Product

      FileMaker Pro

      Version

      11

      Operating system version

      Mac 10.6.8

      Description of the issue

      I have 2 databases which are contact files.  One has 4185 records and the other has 4186 records.  I imported "updated matching records" for the older one with one match field.  The import seems to have worked fine but the import summary show that 13088 files were updated.  Can anyone explain why the number of records is so high?

      Screen_shot_2012-12-05_at_4.09.26_PM.png

        • 1. Re: import question
          philmodjunk

               It would seem that you had much more than 4,000 records in your table.

               One issue that can suprise a person when first using Import Records with the matching fields option is that the import matches records against the target table's current found set. If you have just a few records in the found set and you do an import records, with matching fields and the "add new record if no match" option enabled, you'll update just those few records and then import the rest of the records even if there is a matching record not in the current found set.

               Do this two times and you'll get somewhere close to this number of records.