import matching records issue

[redviper]

hey all,

I am trying to create a solution where the core data is updateable. I have a data source that I import initially to populate the database. I now want to update that data. I have another source file that is a data dump that contains some of the same info as the original source import, some of the records have been updated, and there are new records.

I import matching on a unique field. using the update matching records/import remaining records option. Records update fine but I have 4 new records that all have the same unique ID (the ID is unique to the individual not the record, so, you could have 4 new records all with the same ID because it's the same person).

I can't get but 1 of the new records to import. It won't import all 4 new records and I really can't understand why.

I am using FMdev6. the import files are xls.

any ideas?

thanks

todd

[Vaughan]

The problem is that the imported set has multiple records so the unique identifier isn't unique.

I think you need to reconsider the unique match field and the data structure.

[redviper]

I thought as much, unfortunately I am at the mercy of a data dump from a 3rd party app. guess I could go in and script a record number field. maybe.