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.

Problem Importing when Automatic Deletion is set in Relationships Table

Featured Replies

To allow for easy, simultaneous deletions of a parent and its children, I have started to take advantage of the following setting in the Relationship Table: "Delete related records in this table when a record is deleted in the other table." However, I import data from the user's version of my database into my developer's version by deleting all records from tables in my version and then adding records from the users' version while matching names. I noticed after an import that some tables were missing all their data and figured out that the cause was automatic deletion of records and unlucky order of imports. Because I had arranged the imports in alphabetical order, I was importing the parent (workshop) after its children (team members, offerings), and the children got wiped out because of the cascading effect of the initial deletion of workshops.

 

The ideal solution would be to suspend the cascading deletions set up in the Relationship Table while importing, but I gather that is impossible. What are best practices for avoiding deletion of records while importing? (1) Be ultra-methodical about how one orders imports? (Do the rules against circularity in the Relationship Table guarantee that there is always an order that will work, even with a lot of these automatic deletions set up?) (2) Stop relying on automatic deletions and instead delete children using a loop in a transaction with the parent as the record and the children in a portal? (Inelegant and inefficient.) (3) Use some third way that I don't know about?

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.