Find based on calculation

[DFehrenbach]

I am feeling sooooo stupid!

I am trying to do a Find on a Job table using a calculation field:

 

cCountProductionDays    which is defined as:  Sum ( JobToProduction::cProductionDay? ) (which is a boolean field in the Production table signifying whether or not the Production record is complete)

Extremely simple and straight forward. Displays correctly on Job table layout.

 

When I do a Find operation from Job table using 0, or >0, or =1, or <10, or .... anything - I get "No records match this find criteria"

 

I am CERTAINLY not new to FM, but at the moment I'm completely Brain Locked!

 

 

 

 

 

[Brian C]

Are you doing a search on the calculation field that uses the SUM function or are you doing the search on the boolean field?

Are one or both fields setup to be calculation[number] fields and not something else?