Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - andrea.marchetto

2
Questions / Master detail on two details tables
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.