[FX.php List] Display Calc Field from Related data

[Jonathan Schwartz]

This is a continuation of the previous post regarding scripts in my 
challenge to produce summary data from related tables.   I changed 
direction on how to display my summary data from the related tables, 
taking Andrew's suggestion. Now, I use php and portals to display the 
data directly from the related tables on a summary page.

The problem...I still have one or two fields that require a 
calculation based on data in the related tables: a simple count() 
records.  To my surprise, I've realized the fx will not return a 
value from a calc field unless the field is indexed.  FMP refuses to 
index because it is based on a related field. Catch 22.

Is this accurate?

Movining to another mehtod, I remember discussion of using a regular 
field with a lookup, but could not figure out how to do that. Self 
join and triggered by.....?

Finally, I tried to populate the single field with a one-line 
script...but I just can't get ANY scripts to work AT ALL from fx.php. 
This one was a simple Set Field.

So, I've run out of tools to produce this "simple" result....almost.

My last hope is to execute a a query in the target related table, 
collect the foundCount result and save it for my result.  Seems like 
a long way to go.

Any suggestions?

Thanks


Jonathan





-- 

Jonathan Schwartz
FileMaker 8 Certified  Developer
Associate Member, FileMaker Solutions Alliance
Schwartz & Company
jonathan at eschwartz.com
http://www.eschwartz.com
http://www.exit445.com
415-381-1852