Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

ESS Import - Update Records in FMP; Import New

Mike J
in External Data Sources

Featured Replies

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

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

  • Author

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

Create an account or sign in to comment

https://fmforums.com/topic/84555-ess-import-update-records-in-fmp-import-new/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.