creating a field whose data is parsed out of the data in other fields
I've got a database of images, which have a creator field, a date field, and a location field, and an incrementor.
I'd like to be able to generate file names for the images based on text from those fields.
So for example, if the creator is first name Joe and last name Smith, the Date is jan 6, 2010, the location is Boston, and this is the 4th picture he took on that date in Boston, I'd like to be able to have a field that generates a filename like "JS01062010Bos4.jpg". So that for the data input on the photos, the filename generates automatically based on the data.
Any idea the best way to do that in Filemaker?