AnsweredAssumed Answered

Creating a find based on a calculated field

Question asked by PeterDurant on Aug 19, 2012
Latest reply on Aug 21, 2012 by philmodjunk


Creating a find based on a calculated field



My database has about 25,000 records in it and each record is ranked in importance on a scale of 1-6 based on a calculation (actually a series of calculations).  When I try to search for records based on that number (a field called Rank) FM just sits there chugging away as if it is finding the records but never does.

Other querys are lightning fast, but not this one. Im wondering if there is a problem with FM searching on calculated fields and if so are there any suggestions for solving the problem.