I’m the SysAdmin for our database, and I can delete records. Andrew is a user who is in the EHS group, the members of which have Admin rights for certain sheets. So I would expect that Andrew would be able to do anything I can do for EHS sheets. However, Andrew has tried to delete a test record he created in an EHS sheet, and while it looks like he is able to, the record doesn’t actually get deleted.
How can we set this up to work how we’d expect it to?