unindexed field search not working

Discussion created by NancyAdelman on Dec 29, 2014
Latest reply on Dec 30, 2014 by jormond


FM 12, database with a table of invoices and related table of invoice line items

The invoice table has an un-indexed calc field (Invoice Total) that sums the related invoice lines to get an Invoice total.


I know the find in the Invoice Total field will be slow but it doesn't work. Example; find ">1000" in the finds all invoices.

The un-indexed find works when the file is taken off the server and used locally. the un-indexed find does not work when the file is hosted.

Any ideas how to fix this?


As a temporary work around I created an indexed field and am using a nightly script to move the Invoice Total data to the indexed field. I do not want this to be a permanent solution.


Nancy Adelman