www.hkvforums.com

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.

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

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

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