How customizing Advanced Search

PHPMaker General Discussion (PHPMaker)
1

Hi,i’m using PHP maker 2019 but i’m going to update it to the new one.
I have a technical question to submit, let me describe it :

  • i have a simple master detail
  • i’d like to use the advanced search in the master with a field wich relates to the detail table, i make example :

master is clientsdetail contains all books bought/read by the clientsin advanced search i’d like to have a field in which i select the book and what i expect from the search is the list of clients who have read/bought that book/sis it possible to do this ?

Thanks very much for your reply

2

You probably need to join the master/detail to form a view and perform the search on the newly created view.