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.