4 Replies Latest reply on Oct 20, 2014 12:00 PM by tays01s

    Deleting related portal rows

    tays01s

      Title

      Deleting related portal rows

      Post

      I've got 3 portals for related tables. A button in the parent portal deletes that row. Records correctly delete from this table, it's child and grandchild. However, Although the parent portal row disappears immediately, child/grandchild rows only disappear when I click the window background.

      I've tried including 'commit record' or scripting selection of an object = failure. I'm sure this'll be a simple answer.......??!

        • 1. Re: Deleting related portal rows
          philmodjunk

          Clicking the background Commits the layout's record just like the Commit Records script step, so I am surprised that commit records was not all that you needed to get the other portals to update.

          You might try Refresh window either by itself or in combination with Commit Records.

          • 2. Re: Deleting related portal rows
            tays01s

            Delete portal

            Refresh window

            Commit records or with the last 2 reversed fail to remove the records from the portal.....only the physical click does it. So yes, puzzling!

            • 3. Re: Deleting related portal rows
              philmodjunk

              try refresh window with the flush cached join results option. While that may not be the best final option, if that version of refresh window works, it will tell us something about where the issue may lie.

              And are you actually deleting the child/grandchild records via a cascading delete or does deleting the "parent" portal record simply remove the link to those records?

              • 4. Re: Deleting related portal rows
                tays01s

                I really don't want to have to confess this........but I'd not assigned the script correctly to the button.........as in not at all !!!

                Delete row & Commit records steps are sufficient script steps to remove the parent portal row and, because relationships permit deletion of child/ grandchild portal rows both they and their respective records are deleted.

                Thanks,

                Stephen