I tried to delete a record (after using the self join many to many and reverse lookup relationships), and I get an error saying the record cannot be deleted because it is related to one or more tables.  Is there a way to do this without the user having access to the person with relationships tables?

Thanks a lot.  Really have learned a lot from the seminars.

William

---

Reply from Richard Rost:

If you have referential integrity enforced then you can't delete that record if it has related records. This is a FEATURE of referential integrity. You can either turn it off or force the user to delete the related records first.