Replacing Field Contents

[Tobias Smollet]

I don't know why this is eluding me, but right now I have two fields

field1 = number and field2 = number

Is there any easy way, for every new record, to have field1 set to the value for field2 from the previous record?

[Oldfogey]

Assuming "previous record' means the last record in the table before you entered this one,

1. define an auto-enter serial number field called Serial

2. define a calculation field = Serial -1, called PrevSer

3. define a relationship, LookBack, from PrevSer to Serial.

4. use auto-enter in Field2 = LookBack::Field1