Hey all,

 

I've got the following find command statement. I need it to search on 4 fields, the first 3 being standard items, but the 4th field containing a possible of 4 different options. Any ideas how can I achieve this? Many thanks as always

 

$request = $fm->newFindCommand('Cars');
$request->addFindCriterion('Color','=='.$_POST['Color']);
$request->addFindCriterion('Distance',$_POST['Distance']);
$frequest>addFindCriterion('Age',$_POST['Age']);

$request->setLogicalOperator(FILEMAKER_FIND_OR);

$request->addFindCriterion('Type', 'Coupe');
$request->addFindCriterion('Type', 'Estate');
$frequest>addFindCriterion(''Type, 'Hatchback');
$request->addFindCriterion('Type', 'Saloon');
$requestResult = $request->execute();

 

I think it's called CompoundFind.

 

I tend to sidestep that, and use a calc field that I then search on. Points for laziness, negative points for elegance...

Thanks webko, got it working with a CompoundFind