11 Feb 2024

Dealing with cascade update/delete...

1. Edit item - Will cascade update movement, supplier items, delivery items, and purchase items.
2. Delete item - Will cascade delete movement, supplier items, delivery items, and purchase items.
3. Delete customer - Will cascade delete all related delivery orders, order items, and movement.
4. Delete supplier item > Will cascade delete all related purchase order items and movement.
5. Delete supplier > Will cascade delete all related purchase orders, order items, movement, and supplier items.