2 Replies Latest reply on Sep 21, 2009 11:11 AM by firth5

    accounts and privileges -- not letting me delete records

    firth5

      Title

      accounts and privileges -- not letting me delete records

      Post

      I've set an account that can:

       

      -- see some of the layouts, but within these layouts can create/ edit / delete ALL.

      -- full access to table 1, and view only table 2

       

      However, it's not letting me delete records.

       

      The layouts all use table 1, but are linked to table 2.  Could this link have anything to do with it? (since they can't change table 2?)

        • 1. Re: accounts and privileges -- not letting me delete records
          philmodjunk
            

          Possibly, if the current layout refers to table 2 in Layout setup... and displays related data from table 1. It may look to the user like a delete records action will delete records from table 1 instead of table 2. Since this action will really delete from table 2, the privilege settings will block it.

           

          Another option: Do you have a relationship between the tables set so that records in table 2 will be deleted when a related record in table 1 is deleted? I haven't tested this, but that might explain the issue.

          • 2. Re: accounts and privileges -- not letting me delete records
            firth5
              

            Thanks Phil,

             

            This led me to the right direction.  I forgot about Table 3 -- a table I had started to work with and then discontinued... but I left the relationship intact.  Once I removed that, all is well.

             

            eric