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.

Combining two simple databases

Featured Replies

Hello everyone

I have two simple databases I need to combine. The smallest one is a list of email addresses and one other text field. I need to import these into a larger database of contact addresses

Where the email address already exists in the target table then no import needs to take place. ie a new record is added only where the imported email address does not already exist in the target table. As there are 1200 records to import I am trying to avoid endless find requests

Thanks for reading

Easy as pie.

When performing your import, select the option to "Update matching records." Then, click the arrow between the email address fields in the Specify Import dialog to show a double-arrow, indicating the fields FMI should use to "match" records. Finally, near the bottom of the dialog, check the box to add new records if no match.

  • Author

That has worked fine

Thanks very much

Create an account or sign in to comment

Important Information

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

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.