Hi,

I am trying to perform searches in a calculation field which uses related fields in its calculation to produce statuses (and thus not indexable).

However a find in this calculation field incorrectly generates the error; "No records match this request" when there are records that match the find request.

This link seems to note that this search-ability (in non-indexable) is not possible in older versions of file maker:

http://help.filemaker.com/app/answers/detail/a_id/1812/kw/stored%20calculation

Is this true of FM11 or is there a way around it?

The coding used in the calculation field is:

If ( IsEmpty(po) ; If ( Count ( rfp_link::id_rfp ) ≠ 0 ; If ( Count ( rfp_link::id_rfp )=Count ( rfp::file_quote ) ; "Ready To PO" ; If ( Count ( rfp::file_quote ) ≠ 0; "Rec " & Count ( rfp::file_quote ) & ", Await " & Count ( rfp_link::id_rfp )-Count ( rfp::file_quote ) ; "RFP Out (x" & Count ( rfp_link::id_rfp ) & ")" ) ) ; "Awaiting RFP" ) ; "PO - " & po )

Thanks in advance for any help,

Cheers,

Dan

Do any of the relationships in the calc include global fields? These "don't work" in find mode.

Regarding the FMI doc in the link, that was for FMP 3, 4 and 5. Things have changed since then.

Do any of the relationships in the calc include global fields? These "don't work" in find mode.

Afraid Not :/

However a find in this calculation field incorrectly generates the error; "No records match this request" when there are records that match the find request.

Hi Dan,

I assume that you can see the status in the field and it looks fine? Place your cursor in the Status field and CTRL-I (which displays the index). Do you get only a question mark? If so then the calculation is set to result of number which cannot *see* the text to find it. Try changing the calc to result of text and see if it then works.

UPDATE: If this is not the issue then I suspect the calculation is not properly evaluating in all the cases that you expect.

Try changing the calc to result of text and see if it then works.

It was indeed a silly oversight of not selecting the calc to return a text value instead of a number.

Nicely picked up, LaRetta!