I have two tables joined by a unique ID – is it possible to have two grids on the same page and filter both grids at the same time?
2 Answers
Yes, you have to use 'select_command' property to enter your JOIN query. e.g.
$g->select_command = "select ….. ";
Refer documentation for more.
For searching, it would work with above query. There is a chance that 2 columns may have same name, so you can provide table prefix with 'dbname' property of column to avoid ambiguity.
$col["dbname"] = "table2.field";
Your Answer