11 Replies Latest reply on Aug 21, 2012 6:16 AM by philmodjunk

    Creating a find based on a calculated field

    PeterDurant

      Title

      Creating a find based on a calculated field

      Post

      Hi,

      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.

      Thanks,
      Peter