After performing a find in Table X, I cannot get LookupField_1 in Table Y, which looks up a Summary Field in Table X, to reflect just the summary of the values in the found set.

As an example, Table X lists weekly rental amounts. Table Y generates a report that lists total rental amounts per month. After performing a find in Table X for December, Summary_RentalField (in Table X) gives the total for that month. However, LookupField_1 in Table Y, which looks up Summary_RentalField, still gives the grand total of all weekly rental amounts - not just those in the found set in Table X.

The match fields in the 2 tables have the same value for all records.

This used to work in FM6, but not in FM7.

Any help or suggestions?

is the lookupfield an autoenter or calculation? was the indexing turned on?

I don't think summary fields can be a source for a lookup, since summary fields are dependant on the found set, but relationships are not.

It would probably be easiest to use a sub-summary report in Table X. (It's not clear why you want to base the report on Table Y.)

Thanks Himitsu and Ender for your suggestions. The lookup field is auoenter and can be indexed if necessary. The report needs to be in Table Y because it contains elements of other tables as well - a sub-summary report in Table X wouldn't do the whole report.

I guess you just can't get the summary field lookup to reflect the found set only. Bit irritating though because it definitely worked in FM6.