FM can't do a find in a related summry field

[Edward Newman]

I am hoping this is not true...

I have a Table 'Projects' and a table 'Invoices'. They are related by project numbers. I have a field in 'Invoices' called 'Invoice Amount' for the $ of each invoice and one called 'Sum of Invoice Amounts' which is a simple total summary of the invoice $. In 'Projects', there is a portal to 'Invoices' which works fine and shows all of the invoices for the project. I also have the related field 'Sum of Invoice Amounts' on the layout. This displays the correct total. When I go to find mode, the 'Sum of Invoice Amounts' is not accessible. I checked field behavior and it is set to allow entry in find mode. What gives?

This is actually a subset (or the cause) of a much more complex problem that staretd with the migration to FM7 from FM5.0 The summary fields drive calculated fields which I generate reports based on. I have been trying to determine why FMPro insists that both 'No' and 'Yes' equal 'No' when I find based on my calculated field 'Invoiced Complete'.

Thanks

[Ender]

You can't perform finds in summary fields.

In some cases, you can use relationships to subsets of data and then use an unstored calc with a Sum() function. Searches on unstored calcs are possible, though they can be slower than indexed searches.

[Edward Newman]

Thats what I was trying to do. It worked in FM5, but when we moved to FM7, the finds on the unstored calc stopped working.

[Ender]

Well, it works for me. I think you'll need to be more specific about the field you can't search on. How it's defined, where it's defined, and what table the search is taking place in.

[-Queue-]

If you haven't already done so, clean up your File References under File -> Define -> File References. The problem may resolve itself.