[FX.php List] Query question

[Troy Meyers]

Bob,

As you know I'm new to PHP, but wouldn't the best plain FileMaker way to do this be to do a 'Find' with the fields that are common to all first, and then do a single 'Constrain Found Set' with the catalog number queries each as its own record/request (i.e. ORing them)?

If that works in FileMaker, wouldn't there be a way to set this up in PHP?

-Troy


> This is funny: when I did a search of the old FX emails from the   past,
> I found that I'd asked this exact question once before, and no   one had
> a solution other than to re-query for each different situation.
> 
> My problem is that I need to create a report where there might be 20  
> different catalog numbers, and then the searcher might also include a  
> city or state or zip code. I hate to think that I'd have to do 20  
> different queries to build a single table of results...
> 
> I'd sure love to hear a solution for this one...
> 
> Bob Patin