Return to FileMaker.com
Find is not working as expected
I have a field called Phone 1. I entered the following data in this field:
321-445-2106 voice321-800-1135 cell407-712-7828 fax
I clicked cont F and entered 2106 in the Phone 1 field and came back nothing found.
what am I doing or the program doing that it cannot find the string of 2106?
I have attached a screen shot of the screen and then the find screen.
use *2106 and you should find the record.
Personally, I wouldn't store three number plus text into a single field. I'd use a related table of phone numbers with one field for the "type" and one for the number.
Retrieving data ...