3 Replies Latest reply on Feb 18, 2017 4:37 AM by siplus

    Find function returns records not flagged


      Hi.  I'm wondering if anyone can help me with an issue I have with my FM Pro database in using the "Find" command.  I recently translated an old version of FM Pro v.4.1 to FM Pro v.11, and then I opened it with FM Pro 15.  However, when I search in a particular field set up as a pair of radio buttons.  The results show records that are not flagged in that field, or perhaps once were but are not anymore (I'm not 100%  sure.)  Does anyone have any suggestions on how to "fix" this field so the "Find" function returns only the records flagged as it should?  Why would it return some of the unflagged records?  Your thoughts and suggestions, please.  Thanks!

        • 1. Re: Find function returns records not flagged

          It's hard to tell without more detail. For example, you haven't told us what search criteria you used in your attempt to find the records.


          A few guesses:

          1. Radio button and check box formatting can hide data that is present in the field, that just doesn't match a value of the specified value list--someone may have changed the value list to remove a value or added a value list format to an existing field that already had data in some records... A find might find those records even thought they appear empty. You can make a copy of the field and change it's format back to "edit box" in order to inspect the fields of your found records to see if this might be the case.
          2. Make sure that your radio button field is not from a related table occurrence on the layout where you are performing a find. A field in a portal is almost certainly a field from a related table occurrence but other fields on the layout may also be from a related table occurrence. In Layout mode (with view sample data turned off), such a field will show :: at the start of the field name. When you put search criteria into a related record's field, you are finding records in the layout's table that have at least one related record. Once the layout returns to browse mode, however, the find criteria no longer apply and you may see data in the field from a different record that does not match your criteria or in the case of a portal, you see all related records, both the one that matched your find criteria, but all others as well.
          • 2. Re: Find function returns records not flagged

            Take a look at the field index to see the range of data currently contained in the field. Click inside the field, then choose Insert > from Index—safest to do this in Find mode. The index will show you if there is data in the field that does not match the radio buttons. If so, refer to Phil's first point.

            • 3. Re: Find function returns records not flagged

              Another thing to do is making sure that the values in the radio buttons are 100% compatible with the field definition type.