copy contents of field to new field

[Marcel1]

I have a large database and wish to add a new field to each record that INITIALLY contains the contents of another field, that I can later edit. Is there an easy way to do this?

Marcel

[mr_vodka]

In your Define Field, you can use the Auto Entry option of a Lookup field or Calculated Value

[LaRetta]

An example: If the field you wish to duplicate is Field1 and the field containing Field1's value (until it is changed) is Field2, then an Auto-Enter calculation (with Do Not Replace Existing Value UNCHECKED), on Field2 would be:

Case ( IsEmpty ( Field2 ) ; Field1 ; Field2 )

When a record is created, Field1 will be empty (and so will Field2). When User enters a value in Field1, Field2 will mirror the value. But User can change the value and it will stick. If the value is removed, Field2 will revert back to Field1's value again. Be sure the new Field2 is of the same data type as Field1.

[Marcel1]

Great, thank you!

Marcel