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.