CDML, Relationships, and Valuelists

[Barney1962]

I've got a problem pulling up a pop-up list. It is similar to a more easily solved problem, but I can't get this one...

There are two databases, say District.fp5 and Learning.fp5. Among the many things I care about are two fields in District.fp5, Goals1, and Standards1. Learning.fp5 has only two fields, Goals and Standards. Each goal has several standards. (E.g., the records for the standards "take-off," "height," and "landing" might all have "jumping" as the goal.)

Goals1 is a pop-up, and the value-list is filled from the relationship between Goals1 in District.fp5 and Goals in Learning.fp5. Once Goals1 is chosen in the FMP database, Standards1 is a pop-up, and the value-list is filled from all of the standards in Learning.fp5 that correspond to the chosen goal.

What I've tried is:

<SELECT NAME='Standards1' SIZE=1>

[FMP-InlineAction: -db=Learning.fp5, -lay=list, -findall]

[FMP-Record]

<option value="[FMP-Field:Standards1">[FMP-Field:Standards]

[/FMP-Record]

[/FMP-InlineAction]

</SELECT>

but this merely returns the first 25 records from Learning.fp5 rather than the desired standards. (Yes, I kow that the inital option value is wrong, too, but I'm just trying to get started on this.

How should this be done?

Thanks!

Barney