How do I move a field to another field?

Modify Data

Use Connect to move the value stored in one field and paste it in another field in the same application.

Before you get started

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

Moving a field to another field

1. Open Connect System Management > Modify Data.

2. Click to select Move 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 move.

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 move.

Connect will copy and delete 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 move 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 move 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 and deletes the field value of the source field and pastes it in the destination field.