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.

SELF JOIN & Master Record Deletion

Featured Replies

I have a portal based on a self join (stocks) table.

The portal is based on stocks2 and works well. However, I have an "X" button on the portal row to delete the portal row but unlike my other portals (which are based on regular tables related to STocks), when I press the X on STock2 to delete the row I was surprised to get "Do you want to delete the entire master record or just his one related record."? Deleting the Master Record deletes ALL ENTRIES in the portal .. wow!

I would like the portal row to be quietly and quickly deleted without user 'approval' or a message.

BTW, IN THE RELATIONSHIP JOIN, I HAVE TURNED on and OFF [color:red]"Delete Records in this table when records are deleted in the other table" without apparent consequence or affect.

DO I have to dig up the error code, trap for it, and ignore it??? Or, is there an easier way?

As you can tell, this is my first experience with 'self joins'.

Thanks

None of what you're saying is relevant.

The command you want is delete portal row.

None of what you're saying is relevant.

I think it was QUITE relevant and nicely explained.

Create an account or sign in to comment

Important Information

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

Account

Navigation

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.