Left (Text;number) Function

Yes, I did have it set as a text. Once I changed the field type, it worked. Thanks alot.

Also, I realize that I put left(Field 1;4) when I actually meant right(Field 1;4).

One more thing....

I have a similar issue that has been occurring with lookup values. I have a number of fields that will autmatically populate based on the information put into various other fields. I actually have it set up so that you should really only have to type into one field and then the rest of the information will fill itself out. (Assuming the data being pulled has been put into the correct places in other FMP databases.) Most of my look up fields work but I am having issues with one set of fields that are lookups and are dependent on a specific field called Material Specification. The mat'l spec. field itself is a lookup field based on a field called USB#. The material spec. field populates correctly but the other fields that are dependent on that one do not always autmatically pop up. I basically have to go through the process of recommitting the material specification field and then the other dependent fields will populate themselves. To make matters a little more complicated, this doesn't happene every time. It only happens when certain specifications are referenced in the material specification field. The only thing I can think of is that it has something to do with when the material specification records ( a different related database) were created. Some of the records were made before I had made a relationship between the two databases and some were made after. I have tried copying the material spec. record and then deleting the original (basically making it so that the record was now made after I had set up the relationship between the two databses) but that didn't fix the problem either. If someone could point me int he right direction on this one as well I would really appreciate it.

Thanks, Juan. Once I switched up the field type it worked. Also, yeadh I had the side backwards.