First table that I am deleting from, i'm inserting the new values into. The reason I have to delete from that table is to avoid duplicate values, because this table does allow duplicates and has no way to determine a unique row. So I want to remove the old value and insert the new value. In the front end you can't update the values, only insert and delete. (Name_Add_Fields)

The second table I am deleting from is for the exact same reason, but there is a Unique value in this table. And the only time I want to remove the duplicate value is obviously when I put a new value in.(Pat_Account_Manager).

The way it determines which one to remove is by the @RoleID on the @NameID. @NameID is the client and @RoleID is the Role.