Linking Photographs and Filename extensions

[aesart]

Greetings All!

For a few years now I've worked with a database that included photos of the part numbers, and in this case I use a filenaming software to batch change the item names before importing so that they would not have the file extensions (like .jpg), so that the db would link the photo and display it in the layouts.

Now I have a new set of images (new file) to import into an entirely new field, and was wondering if I could link (relate) the photos and still keep the file extensions...

My first try at a solution was to create a field to relate to that was a calculation that removed the extension from the filename, but what I'm running into is that some of the part numbers begin with the number "0" (based on the vendor's original part number, otherwise I wouldn't use it), and the calculation is removing those leading zeros. (Not all the part numbers have leading zeros)

Anybody have any ideas?

Dev 6, Tiger, G5

[aesart]

Well, I solved it...

I had the calculation result as "text"... When I changed it to "container" I was able to keep the text as entered... So I created a calculation in one file like this:

(partno+'.jpg")...