How do I copy a field to another field?

Modify Data

Use Connect to replace a field value with a different field value.

Before you get started

Back up the database. See the help topic titled How do I back up a database?

Copying a field to another field

1. Open Connect System Management > Modify Data.

2. Click to select Copy a Field to Another Field.

3. Click Next.

The Select Field form displays.

4. Click to select the table that contains the field you want to copy.

The fields in the table display in the section titled Fields. You'll want to make sure the field you want to update is included in the list.

5. In the section titled Fields, click to select the field to copy.

Connect will copy the contents of this field. Now, select the destination where Connect will paste the field value.

6. Click to select the table that contains the field you want to copy to.

The fields in the table display in the section titled Fields. You'll want to make sure the field you want to update is included in the list.

7. In the section titled Fields, click to select the field to copy to.

8. Click Next.

The Criteria form displays. You can use the Selection Criteria to select a range of records, dates, accounts, etc. If you want to update the value in all of the fields in the table, skip the next step.

9. Set up the selection criteria to apply additional filtering requirements.

10. Click Next.

The Set a Field Value form displays. Connect summarizes what will happen to the table when you click Continue. If you need to make any changes, click Back to make changes.

11. Click Continue.

Connect copies the field value and pastes it in the destination field.