title: Deleting a record without deleting related records in another Access table
body: <p>I have enabled Referential Integrity in Access 2007. I want to delete a customer record from customer table but want to keep related bill details of that particular customer in another table called bill table. When I try to delete a customer record I get an error message: "The record cannot be deleted or changed because table 'bill' includes related records".</p>