Portal to a summary field of a found set.

[miwok]

In FMP 6 a script in reports.fp5 runs an external script in another file (customer.fp5). Customer.fp5 performs a find on all the active customers. Reports.fp5 then sets fields based on the summary fields of customer.fp5. The relationship is based on a simple field called "key" that has the same value in both reports.fp5 and all the records in customer.fp5

My problem is that when the database was converted to FMP 7 the script does the find okay, but reports.fp5 sees the summary of all records in customer.fp5, and not just the found set.

Any ideas on why this is happening?

[-Queue-]

It seems like customer should be setting the fields based on its found count. reports wouldn't know which records are found in customer and summary fields are local, not to be trusted if used in other tables/files.

[miwok]

Thanks for the help. I quess I will have to write a script that copies the summary fields to a global after each find.