How to add a master/detail form

January 03, 2019, 03:37:14 AM

Hi guys,

How can i create a master/detail form?

,

Thanks in advance guys

Re: How to add a master/detail form

Reply #1 – January 03, 2019, 05:59:03 AM

Hi Frazesa69,

Please if you can provide more details of what you want to acheive.

But here is the basic of PHPRad master detail relations.
https://phprad.com/tutorials/phprad-master-detail-pages.pdf

Regards

Re: How to add a master/detail form

Reply #2 – September 11, 2019, 05:27:38 PM

Hi everybody...

Please, does anyone can provide a real example of master detail screen with customers orders and items.

In this example would be great if we have the ability to:

1 - Search for customer to whom the order will be generated. Must be able to search the customer by any info on his record.
2 - Order and its items on the same form if possible.
3 - Add, edit or delete items of the order on grid or modal form.
4 - Any change made to the items must be reflected automatically to the order fields (total of discount, freight cost, order amount)
5 - Search for a product by any info on its record to be added in the items grid. When product id added, the unit price must be filled with the product´s price and qty x unit price calculated.
6 - Print order when saved to a pdf.

Is this possible in PHPRAD Classic?... a lot of people ask for a master detail example and the link provided by Emman (https://phprad.com/tutorials/phprad-master-detail-pages.pdf) is not what we are looking for. The provided link does not work in a real world applications.

Hope someone can help.

Thanks