Searching In Unstored Calculated Field

[DanMarks]

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

[Vaughan]

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.

[DanMarks]

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

Afraid Not :/

[LaRetta]

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.

[DanMarks]

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.

[Vaughan]

Nicely picked up, LaRetta!