copying content of multiple records

[Pierre]

I'm trying to manipulate two fields within my inventory database-"current" and "previous". I need to move the values in the current field to the previous field.I can cut the values from current and paste it into previous, but this one record at a time will be very tedious. Is there a way to do this in one shot?

Any ideas would be greatly appreciated.

[Maarten Witberg]

Hi.

 

Create a found set and loop through the records. Script:

 

Code:

---

#create found set first if needed#
go to record [first]
loop
set field ["previous", "current"]
go to record [exit after last, next]
end loop

---

 

You will now end up with the same (current) values in Previous and Current.

 

kjoe