I am using PHPmaker v2024.8.
I have table structure as follows:
--- table1
--- table 2
--- table 3
These are related as master/detail tables (Add/Edit/View). So I can expand the different rows from the detail tables.
Now I would like to add a filter in the function 'Recordset_Selecting(&$filter)' on table 3.
For this I need to capture the value of table1.categoryCode.
The filter is AddFilter($filter, "category = $table1Category");
Is there a function to capture the value from the column table1.category to use as a filter on table3?
The other scenario is to get a value from table2.categoryId and use a MySql to retrieve table1.categoryCode (SELECT categoryCode FROM table1 WHERE id = $table2.categoryId)
How do I retrieve the $table2.categoryId from table2 (mastertable) from the table3 (detailtable).