Search in multiple tables

silvana · Post by **silvana** » Mon Feb 16, 2015 8:42 pm

Dears,

as a example we have have 2 tables,

--- orders
--- order_id
--- customer_id
--- employee_id
--- etc

--- order_details
--- orderdetails_id
--- order_id
--- unit_price
--- extended_price

now if i need to search between two tables, what can i do ?
i mean the important parameter to search are customer_id and extended_price, how can i search for both parameters between two table in phpmaker.

mobhar · Post by **mobhar** » Tue Feb 17, 2015 10:39 am

You may create a Database View that joins those two tables, and use it to generate the List page that contains the Search feature.

silvana · Post by **silvana** » Wed Feb 18, 2015 8:47 pm

if i did not use view, is it possible to change search parameters in parent table to search some field in child ?

mobhar · Post by **mobhar** » Thu Feb 19, 2015 9:39 am

You can only search the field in detail table from the master record section, as long as the field exists in the master table.