how to display unlinked fields from details tables on Master pages?

Yes, it is possible to display additional fields from related detail tables (B, C, D) in the master table view in PHPRunner without altering the structure of the master table A. You can achieve this by using the "Add a Lookup Field" feature in PHPRunner.

Here’s how you can do it:

1. Open PHPRunner: Start your PHPRunner project and navigate to the desired master table (A).

   
   

2. Go to the "Fields" Section: In the main menu, click on the "Fields" section of the master table (A).

   
   

3. Add a Lookup Field:

   • Click on the "Add" button to create a new field.
   • Choose "Lookup Wizard" or "Lookup Field" from the field options.
   • Select the appropriate detail table (B, C, or D) from which you want to pull the extra field (e.g., B.bbb).
   • Set the relationship based on the foreign key/linked fields (e.g., A.xxx with B.xxx).
   
   
   
   

4. Select the Display Field: In the lookup field settings, choose the specific field from the detail table that you want to display (e.g., B.bbb).

   
   

5. Configure Display Options: You can adjust how the field will be displayed in the master view (e.g., as a text field, dropdown, etc.).

   
   

6. Repeat for Other Tables: If you want to add fields from other detail tables (C, D), you can repeat the steps above for each table.

   
   

7. Save and Build: Once you've added the necessary lookup fields, save your changes and build the project.

   
   

8. Preview: After building, preview your application to see the master table A displaying the additional fields from the detail tables (e.g., B.bbb).

   
   

By following these steps, you can effectively display additional fields from related detail tables in the master table view without modifying the underlying structure of the master table itself.