I have a very simple script to duplicate a record, and add ".1" to a certain field.

Duplicate Record/Request

Set Field [Main table2::Transaction $; Main table2::Transaction #+".1"

It basically works, (and if I duplicate a duplicated script, it changes the .1 to .2 which is useful, but odd it does that without me telling it to) but the field it modifies usually has a hypen, which is deleted in the duplicate record field.

The original record will show "2003-25", while the duplicate record will show "200325.1".

Why is it deleting the hypens, and how do I prevent this?

Keep it as text, instead of the typecast - This means use & instead of the +

--sd

Thanks, that worked.