Copying from different field in previous record

[emerywang]

Hi. Anybody know the easiest way to copy the data from a different field in a previous record? For example, say you have 2 fields:

1. Starting total

2. Ending total

When I create a new record, I want the data in the previous record's "Ending total" to be copied into the new record's "Starting total" field.

Thanks,

-Emery

[BobWeaver]

1. Create a stored calculated field "Const" with the formula "1"

2. Create a selfjoin relationship "sj" using field Const on both left and right sides of the relationship.

3. In the autoenter options for Starting total, select "calculated value" and enter the formula:

Last(sj::Ending total)

[ralph.nusser]

Thank you, Bob.

For Newbies the attached file according to Bob's cookbook.

Uebernahme von vorherigem DS.zip

[emerywang]

Thank you, thank you oh thank you, to Bob for the answer, and Ralph for posting the attachment. Couldn't have done it without either of you.

-Emery