Search in the Details Table from the master Table List page

PHPMaker General Discussion (PHPMaker)
1

I have created a Master/Detail page with Multiple Detail Tables
Table1 → Master Table
Table2 → Detail Table
Table3 → Detail Table

I have use the Details Preview Extension

Now on the Master List page There is a Quick Search Option which search only the Master Table Record

Using the Master Quick Search panel, how can i search both from the Master and Details Table (There is 2 Details Table)

2

You cannot search across tables, but you may create a view to join the tables first and use it as the master table (you can select just the master table fields to show).

3

I have created a view and make it as Master Table.
It show correctly for those records which have only 1 records in the Details Table.

But if there is more than 1 records in Details Table for the record in the Master Table
then it show more than 1 records with the same data in the Master List Page.

4

It depends on the SQL of your view, you may try to refine it.