2. PHPRunner General questions
  3. [SOLVED]   Master Detail Pages
This topic is locked
[SOLVED]

  Master Detail Pages

 		1/4/2013 8:15:38 AM
PHPRunner General questions
P
 pbais author

One of the greater features of PHPR since version 6.0 (or was it earlier?) is the possibility to show master and detail records on the same page.

But I am not happy with the presentation. See attached screenshot.
The part of the page containing the detail records is always aligned left (without a left margin), regardless of the alignment of the masterpart (which is centered by default, as in the example).


Is there a way to keep the details aligned with the masterinfo on the page using the style editor?
And does anyone know, how to change the style of the detailheader/title using the style editor?
Maybe a new enhancement/feature for a next release of PHPR:

It would be even better, if the detail records would be shown by using the tabs/sections as they are available for the view page (to group items from records with many fields).


So, there would be a master record called 'Sales Person', and then for instance tabs containing child records like 'Sales Orders from Sales Person' and 'Training and Certification of Sales Person', and 'Stores attended by Sales Person', and so on, or whatever.
that would be sweet!
Kind regards,

Peter

NL
Sergey Kornilov admin 1/4/2013

Centering details info or left-aligning the main record is not difficult and can be done via Visual Editor or Layout Editor customization.
The main issue is that details table is typically wide and it would be tough to make look good together with master record info which is positioned vertically. One of approaches is to display details table info in the tab. Add tabs to your master record View/Add/Edit page, then cut and paste details table info to one of subpages.
You can get something like this as a result:

http://xlinesoft.com/livedemo/phprunner/livedemo1/orders_view.php?editid1=10248

Check 'Order details' tab.
B
 		btrdev 1/4/2013



One of approaches is to display details table info in the tab. Add tabs to your master record View/Add/Edit page, then cut and paste details table info to one of subpages.
You can get something like this as a result:

http://xlinesoft.com/livedemo/phprunner/livedemo1/orders_view.php?editid1=10248

Check 'Order details' tab.


Can you give some more detail about how to accomplish this? I've found PHPRunner to be very good, but for projects that require robust master/detail forms, I've just not been able to get it done satisfactorily in PHPRunner and had to use other products instead. Perhaps this workaround with the tabs might help.
Sergey Kornilov admin 1/4/2013

Create Master-Details relationship. Make details display on Add/Edit/View pages of the master. Proceed to 'Fields order and totals' screen and add tabs to the View page of master table.
Proceed to master table View page in Visual Editor. Make the yellow 'displayDetailTable_...' rectangle selected. Cut. Open one of tab pages/subpages. Paste.
This is it.
P
 		pbais author 1/4/2013

Sergey,
The example you posted is exactly what I am looking for. Thanks. I'll start playing with it this weekend.
Regards,

Peter

Netherlands
J
 		johnP 1/5/2013



Create Master-Details relationship. Make details display on Add/Edit/View pages of the master. Proceed to 'Fields order and totals' screen and add tabs to the View page of master table.
Proceed to master table View page in Visual Editor. Make the yellow 'displayDetailTable_...' rectangle selected. Cut. Open one of tab pages/subpages. Paste.
This is it.


Hello Sergey,
Can you explain the example more in detail for me.
Thanks