I have a text field that uses numbers, like 1234, I want to be able to add 1 to the last number and
place it in a table.
I start with; 1234
I add 1: 1235
I add another:1236 and so on.
then this would b e placed in a table called fun one. in a field called counter1
I cannot use auto number because it is used as the Id field.