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?

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.

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.

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.