ESS Import - Update Records in FMP; Import New

[Mike J]

Hi ALl,

I have some experience with SQL syntax and our DBA allows us to import records and not write to the SQL data source. I have a local FMP 12 identical to the SQL source. I can import all records in the first instance easily.

However, there is no option when field mapping to only update related records then add new.

Is there an SQL where statement or and indexing issue on the SQL side?

Thanks

Mike

[mr_vodka]

did you choose the option of 'Update matching records in found set', with the addtional option of adding the remaining as new records?

[Mike J]

That option is greyed out. I would do that, this is why I think it's indexing issues on the SQL side