2. PHPRunner General questions
  3. Display 2 levels of master table info
This topic is locked

Display 2 levels of master table info

 		8/28/2007 6:43:44 PM
PHPRunner General questions
V
 vytb author

Hello,
In the multi-level application, displaying one-level mastertable info can be not enough. The absence of higher master info often confuses the user. I wonder if it could be possible to make display two infos of two level mastertables?
For example, master table is 'user', child table is 'user_info', secondlevel childtable is 'user_info_1'. Then, being in 'user_info_1', we won't see the info about the user itself an only info from 'user_info' which has not info from 'user'.
Anyone has an opinion or/and code sample?
A
 		alang 8/28/2007

One technique I have used to address this issue is to have the "mid-level" SQL include details from the upper level master table (using inner joins). You can then make this field visible on the Master Table info (list) view in the visual designer.
V
 		vytb author 8/28/2007

One technique I have used to address this issue is to have the "mid-level" SQL include details from the upper level master table (using inner joins). You can then make this field visible on the Master Table info (list) view in the visual designer.


Thanks Alan,
I'll try this way.