NancyAdelman

unindexed field search not working

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

All,

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

www.adelmandatabases.com

Outcomes