Delete Query?

[Scottyg1987]

I have attached a relationships diagram to help with this query I have.

I want to delete customers, however I know that if I simply do this all associated records will also be deleted.
I want the orders that these customers have made to remain within the database. So, when a customer is deleted all records
associated with them are deleted, except their order details, payment method, credit card type, and City.

I have an idea that perhaps this can be achieved through a delete query but do not know if and how it can be done.

Please explain the answer in easy-to-follow steps as I am new to access.

I appreciate your time and knowledge.

 

[Rich]

Why not just archive the Customer?

 

[Liv Manto]

Edit the relationship:

Uncheck the delete.