Perform Find on Related Records

[cjoyce]

Seems like this should be easy, but I can't figure out how to do it.

I have a layout and it has a portal to a related set. I want to perform a find that returns records that match a field in the related set.

For instance, I have a students table and an applications table that is linked to the students table. I have a layout displaying data from the students table with a portal to the applications data. How would I return the records from this layout that have have applications submitted in the last week?

[aldipalo]

Do you have the Application Date field in the portal?

If so, in the application date field enter:

09/15/2008...09/20/2008

If not, you need to add the field to the portal.

[cjoyce]

Sorry didn't mention that I meant how would I do this via PHP using the FileMaker PHP API, not in the FileMaker Find interface.

[Baloo]

Fist Off: You'll be a lot happier with your page load times if you make a new layout based on the assignments table and search it.

To answer your question: It's pretty much the same thing.

$fm = new Filemaker($database, $server, $user, $password);



$layout = "myLayout";

$findAllq = $fm->newFindCommand($layout);

$findAll->addFindCriterion("submission_date", "09/15/2008...09/20/2008");

$result = $findreq->execute();

use PHP's date() and strtotime functions to get/set the endpoints of your range.