Auto increment field number when record duplicated
I am using FM12 and have a table in which I want to be able to duplicate records, so that I don't have to re-enter all the time when only one or two variables change.
I have created a Duplicate Record button which works okay but would also like to increment the number in a particular field by 1 as soon as the new record is created. Is there anyway I can do this?
Thanks in anticipation