This topic is locked

Search for number of detail records

1/28/2014 4:06:23 PM
PHPRunner General questions
W
wpl author

Hi all,
this has kept me thinking for quite a while now: given a master table with one or more detail tables, how would one - let's say starting from the advanced search page of the master - search for master records with a certain number of detail entries? Or for master records with no detail records at all? I know how this can be achieved with SQL but would prefer this to smoothly fit into to the seach mechanism of PHPRunner.
Thanks for any input