This topic is locked
[SOLVED]

 Multiple Master tables on Dashboard

12/17/2014 7:20:38 AM
PHPRunner General questions
G
GunnySJB author

I want to create a dashboard that has three tables.

The first is the master table of the second and the second is the master table of the thirty.
How can i do this.
I have created a dashboard like explained. So put the master table on the dashboard twice. First time as a grid and second as detail. But now the second must be the master of the thirth.
Has anyone done this ?

Admin 12/17/2014

This is not possible in the current version. We plan to add nested master-details relationships on dashboards in one of the following versions.

G
GunnySJB author 12/17/2014

Thank you for the info, hope it will follow soon

A
Anapolis 1/10/2015



Thank you for the info, hope it will follow soon


I have needed something similar to this for years. I hope it is high on priority list!
For the past few years for numerous projects I have needed a full search capability to exist on the same page as a form.

All these projects need to search records from a master table by various fields. But usually they must start with the Zip code.

When they see multiple records with the same zipcode as the filter then they can recognize the record they need by viewing other fields.
The desired action at that point is to simply select the record of their choice that then auto populates the form with needed fields below the search view, and the user fills out the other fields before saving.

The form that is populated with data from the master record can not be designated a "detail" table by PHPRunner.
And I cannot designate the zipcode field in the form itself as a "Google-like" suggestive search because numerous records appear in the popup that cannot be differentiated even with multiple concat expressions to display other information in that record.
The concats, if there are too many, begin to fail or cause errors during the search via ajaxed zipcode lookup.
So, the ability to designate ANY table as the recipient of the master table search, and to populate fields in the waiting form without leaving that form window will be a GREAT and extremely useful enhancement of PHPRunner.
Thank you!