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

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.

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.

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.

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