Lookup summary field problem after a find request

[lefkovj]

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?

[Himitsu]

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

[Ender]

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.)

[lefkovj]

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.