As I mention have two way to avoiding of deleting invoice if you delete customer first 1. PHPrad have no SQL constraint when create DB, you can go to mysql and using add Foreign key to the Child Table. in this way when you delete customer have invoice relationship --> error showing up.
2. you can add colum to customer like 'is_deleted' to remove customer showing but not real delete, phprad new version support that.
I also tried to find and remove cascase delete but not work
Hi I Think you can add foreign key to children table or at new version of PHPrad which have soft deleted that maybe avoid deleting database Hope is help Thinh
I have Sale Table as below, sale_id customer_id product_id qty amount 1 1 1 10 10$ 2 1 2 5 5$ 3 2 1 10 10$ 1 2 1 5 5$
Now I want to make invoice for each customer in one page and can print all invoice, or export all invoice to PDF file with break page Any body suggest me how to do is appreciated Thanks
