serial number generation based on specific criteria
I am using the filemaker photo catalog modified with additional fields.
I create an auto serial number when I import files, now i need to create a
separate serial number when there is no photo. example; field name = photo id
when improted it will either be a camera id number (dscn123.jpg) or one
geneerated for no photo dscnnophoto.jpg. All records create a serial number
in the field epa cert number, now i need to create a new set of serial numbers
that are generated ONLY when the field = dscnnophoto.jpg. I have tried scripts using if
and set variable and am either doing something wrong or this is not the right path.