Re: cannot delete from table service without cascade

null@example.com (derek) — Sun, 01 Jun 2025 18:46:17 +0000

I would suggest adding an 'expiry date' to your services table and then add a small script to check if any new orders try to use a service that has expired.
This means that old orders that were raised before the service expiry date will still be accessible.
See attached for a basic idea.
Derek.

cannot delete from table service without cascade

null@example.com (IgorMad) — Sun, 01 Jun 2025 17:40:22 +0000

Hi,
i have problem with my project,when i wanna delete service it does not allow me to delete.
Lets take example:
have many services/items to sell, i created orders and invoices for items that i sold but now i dont have anymore service1 in my shop to sell.
when i wanna delete that service i cannot.
is there any way to delete obsolete services but to stay in orders and invoices that are already created?
i know i can delete if i make cascade delete but then deletes all services from already created invoices or orders.
Thank you

My Visual Database — cannot delete from table service without cascade

Re: cannot delete from table service without cascade

cannot delete from table service without cascade