Related Search Limitation?

[GordieH]

Hi all,

Is there a limit to FileMaker's API for PHP/CWP in terms of searches to related tables? It seems that I can search "1 relation deep", but I can't go "2 relations deep"

I have three tables: STUDENTS, ENROLLMENTS, and PROGRAMS. The first, STUDENTS, has a single->many relationship with ENROLLMENTS (since students enroll into subsequent semesters). ENROLLMENTS has a calculation field bringing in the Location of the Program to which the student is Enrolled with a single->single relationship to the PROGRAMS table. The field that I'm searching is a calculation "lookup" based on the ProgramID field that the ENROLLMENTS table holds and matches to a unique ProgramID in the PROGRAMS table.

I've tried it with and without the STUDENTS->ENROLLMENTS portal around the field STUDENTS->ENROLLMENTS::IN_PROGRAM_Location (no, I don't have arrows in the real names).

When I do a simple search in FileMaker for, let's say for New York, I get a number of results -- with or without the portal on the layout.

When I do the same search of the field STUDENTS->ENROLLMENTS::IN_Program_Location in my PHP script I get 0 results.

This is my code for the searches that don't return results:

$find->addFindCriterion("ENROLLMENTS::IN_Location", $_POST['location']);

Other searches to data fields in the ENROLLMENTS table (i.e. ENROLLMENTS::Status) are working correctly, but they do not include a calculation to another related field.





For example, this works:

$find->addFindCriterion("ENROLLMENTS::Status", $_POST['status']);

I'm thinking this is a limitation to the API/CWP, but if someone can answer me definitively, I'd be most thankful!

Thanks!

Gordie

Edited August 14, 2009 by Guest