2 Replies Latest reply on Feb 16, 2012 3:29 PM by sphilipr

    Problem deleting lines in a portal

    sphilipr

      I have multiple instances of portals in set of realted files I'm making based on the Filemake Business Productivity suite that I downloaded from filemaker.

       

      My portals are drawing in information from related files to genertate sales orders and contact info in invoices, sales forms etc. However everytime I delete a row in the portal of say an item in a sales order drawn from a related inventory file the deltetion removes all the records in the portal, it doesnt just delete that one line from the portal.

       

      In the working exampe, in the busines productivity suite this doesnt happen only the instance or row in the portal disappears the line the rest is unaffected. As this happens with every portal I create I can only deduce that I'm makeing a basic error in the way I set up the protal.

       

      Any ideas about how to cure thei?

       

      Thanks

       

      Philip Riley

        • 1. Re: Problem deleting lines in a portal
          Stephen Huston

          I haven't worked with the file you refer to, but you are experiencing what is called "cascading deletes".

           

          Go in an check the relationship among all of the tables to be sure that the checkbox to delete all records in table X when deleting a record in table Y is only checked on one one of the two tables, not both. Then check that you don't have it set in other TOs for the same table to trigger deletes where their not expected.

           

          I've know people to set everythig to delete thinking it would clean itself up, only to lose EVERYTHING in all tables when they deleted a record somewhere.

           

          It's all controlled from the relationship graph dialogs for setting  the related fields between each pair of related records.

           

          Check them all if you aren't sure where it's coming from, but it's most likely the parent TO of the layout and child TO of that specific portal.

           

          Also, NEVER turn on a related delete in a relationship between TOs for a self-related join.

          1 of 1 people found this helpful
          • 2. Re: Problem deleting lines in a portal
            sphilipr

            Thank you for that answer.

             

            As you correctly deduced I had my permissions for creating and deleting files in related record a littl tied in a knot.