Numbers beginning with zero

[bdalton]

I have a database that holds all of our projects. I started it in 1998 and our project numbers from then forward have always started with a 2-digit year (ex. 07085 would be the 85th project of this year). We recently decided to add all legacy projects to this database which were 4-digit numbers with no date relationship (ex. 7085). Now that those projects have been added when we use a form that is related to the project DB and a user enters 07085 for the project #, FMP pulls the info from 7085 (ignoring the initial zero). Is there a way to make FMP compare all numbers and not ignore leading zeros? Thanks

[Raybaudi]

Hi

change that field from number to text

[bdalton]

That was the first thing I tried but I must not have done it to both databases because it works now. Thank you for your help.