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

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)

Thank you, Bob.

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

Uebernahme von vorherigem DS.zip

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