Hi there,

I would like to know if someone can transfer data (number) from the last record to a new one.

Let say that I have 3 number fields (A - B - C). By clicking the 'New Record' button, I want to transfer information from the third field of the last record to the first field of the new record. I developed a script to do that but nothing happened.

Any help would be great!

Bikeman

You can create a global field to store the number before you create a new record then transfer it to the new record:

show all records

unsort

go to record [Last]

set field[gNum, C]

new record request

set field[A, gNum]

Regards,

Henry

Henry,

I didn't realize the C field is calculation of A + B. I guess it creates another problem?

Bikeman

Bikeman:

In that case, create two global fields, gNumA and gNumB, and use Henry's method to set your A and B values via those globals; the C value should calculate itself.

-Stanley