TheTSart Posted May 29, 2004 Posted May 29, 2004 I have been using a Cue Cat to catalog a collection I have. Yesterday, though, FM PRo 7 could no longer find the data the Cue Cat inputted. I took out the spaces in-between the two sets of numbers and it found the record (the barcodes I'm reading have two parts). I've been doing this for at least two years now and this was never a problem before. I tried several other programs and FM was the only program with this problem. So, I tried entering the barcode into a text field, instead of a number field, and it works just fine. I hesitate changing the barcode field to text because I don't know if this is an aberration due to a Mac OS update (I just did 10.3.4) or the way things will work from now on... Any thoughts? Thanks! Tim
RalphL Posted May 29, 2004 Posted May 29, 2004 From FM help: "FileMaker Pro indexes the first 400 significant digits (numbers, decimal points, or signs) of the field, ignoring letters and other symbols." It looks like you will need to change to a text field if you want to keep the space character.
stanley Posted May 29, 2004 Posted May 29, 2004 Tim: Unless you're going to do math with a field's contents, there's really no reason to make it a number field. All the barcode fields I use are text fields, even though most of them contain only numbers. -Stanley
Recommended Posts
This topic is 7744 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now