2 Replies Latest reply on Apr 24, 2012 7:16 AM by matronryan

    Delete portal row deletes all portal rows



      Delete portal row deletes all portal rows


      I have found a number of posts relating to delteing portal rows but cannot find something on this problems.  I have a button in each of the portal rows which uses the delete portal row control.  But when I use it I get the dialogue "Perminately delte this one related record" I click delete but then it deletes all the portal records related to the main record.  Am I doing something stupid. Any help appreciated.




        • 1. Re: Delete portal row deletes all portal rows

          By any chance is it also deleting the main record also?

          It sounds like you have a cascading delete specfied in one or more relationship in Manage | Database | Relationships.

          One possible scenario is that you enabled the "delete" option for both sides of a relationship between the layout's table and the portal's table (could be in a different set of occurrences than the ones specified for your layout and portal.) Deleting the portal records would then also delete the parent record and in turn that would delete all the other related records.

          This is just one possible scenario. Other possible cascading delete's might produce this result. You'll need to review the relationships in your file by double clicking them and looking for these delete options to see if you can identify the one that needs to be removed so that this does not happen.

          • 2. Re: Delete portal row deletes all portal rows

            Thank you very much - this solved my problem

            Thanks again