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.

assigning primary keys retroactively

Featured Replies

at my company i just inherited a 20,000 record contact database that i'm trying to make relational (in a many-to-many way). of course, no one ever gave primary keys to each record in this db. is there a way to assign unique primary keys retroactively? i've created a field with auto-enter serial, etc., but i need to avoid putting number in 1 by 1 by 1...

Sure, put the cursor into the new ID field and do Records->Replace Field Contents. In the dialog that follows, select the 'Replace with serial numbers' option, and have it update the serial number in the Entry Options.

The Replace Field Contents command, in the Records menu (and a script step) has an option to "serialize" the found set, with an Option to reset the auto-enter "next" number (or text). It can do 20,000 in just a few seconds.

But that's just a serial number for the current records. Are there really 20,000 unique contacts? Have you seriously checked?

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.