Skip 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.

When Filemaker fails to prevent duplicate records being created

Featured Replies

There is a good description of how to set up validation in Filemaker in order to prevent dulicate records being created here: http://fmforums.com/forum/showtopic.php?tid/176348/post/204677/#204677. This post is concerned with the cases in which even these methods fail.

We have implemented option 1 in the above post, defining a unique key for each record and using the Unique validation requirement to ensure that no duplicates are created. However, we still occasionally get duplicates being created. Does anyone have a list of scenarios in which this can happen?

In our case, the records in question are all in "incidental" join tables and are created from a parent record as a related record in a portal, typically by selecting an option from a drop down list. In normal use, attempts to create a duplicate prompt the standard "Revert" warnings. Nonetheless, some duplicate records appear from time to time.

The only explanation we can think of is that occasionally the user may force quit the application while the Revert warnings are on screen.

Can anyone confirm this, or cite other scenarios?

Then the question will be, what can we do about it?

many thanks in advance,

W.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.