February 9, 201015 yr I am consolidating a FMP file and an Excel file (Converted to FMP) into a new file for an expanded DB. On either one of these the Find function does not work for certain fields that contain mixed text (e.g. an address or an email address). When I try to do a find for these fields, I get a No Records Found message. If I enter just a the street name, or just the address number, I get hits OK. These fields are Indexed Text fields. Any help gratefully accepted.
February 9, 201015 yr The @ sign is, unfortunately, a reserved character for Filemaker finds. You can try entering a literal string (put quotes around the e-mail address) or change the indexing of the field, which will make finds case sensitive.
Create an account or sign in to comment