Master detail on two details tables

June 13, 2019, 07:37:44 AM

Hi,
just purchased PhpRad after a quick evaluation but I can't find the right way to do this:

This is my database:

Master table: productions
Fields: id, (other non important fields)

First details table: production_temperatures
Fields: id, production_id, (other non important fields)

Second details table: production_pressures
Fields: id, production_id, (other non important fields)

Referring to https://phprad.com/tutorials/phprad-master-detail-pages.pdf :
For master-details setup I need to click on "production_id" field ("production_temperature" table) and then click on "SetRelation", but in this way I see that "production_temperature" is used as master (this table is the details!).

And if I try to click "SetRelation" on "id" field ("productions" table) I can set only 1 relation but I need to set 2 relations (on both "production_temperatures" and "production_pressures").

So how can I reach my scope?

Thanks in advance.

Re: Master detail on two details tables

Reply #1 – June 13, 2019, 01:57:53 PM

Hi Andrea, im new too here i test that back to you.