2. PHPRunner General questions
  3. Master and Detail on the same page?
This topic is locked

Master and Detail on the same page?

 		1/11/2007 6:22:12 AM
PHPRunner General questions
A
 asimha author

Good day,
I have 2 tables one with the master data and one with the detail.
Is there a way to display the details on the master page without having to open a new form ?
Thank you

Andre
J
 		Jane 1/11/2007

Andre,
you can do it editing your SQL query manually on the Edit SQL query tab.

Here is a sample query:

select `mastertable`.`field1`,

`mastertable`.`field2`,

`detailtable`.`field3`,

`detailtable`.`field4`

from `mastertable` inner join `detailtable`

on (`mastertable`.`field1`=`detailtable`.`field3`)



Then modify appearance of your LIST page on the Visual Editor tab.
A
 		asimha author 1/11/2007

Thank you Jane I had already read this response in another thread, the problem is that the Master record is repeated on each line, whereas I just wanted basically the look of the "Details page" with the Master at the top. Maybe I can see the URL and call the details page directly ...
As always, thanks for your help!

Andre