Why Exact Match Is N0t Relating-Importing

[datashouldbefree]

I have data base with unique ID numbers for every record in the data-base.

Data-base1 has 920,000 records. data-base 2 has 6,000 records. All of the records in databse 2 have matching IDs with Database 1. (In fact all of the IDs in database2 came from Data-base1, which were sent out to get some new data added to them).

Now, when I attempt to import the new data added to the 6,000 records in data-base2 into database1, some of the records are droped. for example: A136756 is a common ID between both data bases. However, when importing the new data into database1, Filemaker fails to import from this ID. I am loosing about 700 records.

I have the two data bases in a seperate program and matched/imported the new data in that program, so I know all of the IDS are correct. (I need the formating functions in filemaker, otherwise I would not be bothering..._

Any thoughts as to why Filemaker is failing to import some of the IDs and not others? The ID in databse one is generated by parsing a long ascii record/text string.

[LaRetta]

Is the file with 6,000 records (database2) open when you execute the import? Are you on a layout based upon database1 at the time? If you import from database2 when it is closed then it will import all records; otherwise, it will only import its existing found set. And if not all records are shown in database1 when you import, it will only update those records which are part of your found set.