#### Using the Set Location process

When you choose Set Location from the Database menu and specify a new location for the active database, the program checks the database for changes.

Set Location displays the Map Fields dialog box when it detects any of the following changes in the database structure:

- a database field has been deleted
- a database field has been renamed
- the database is completely new.

Note: The program checks for these changes only if the databases have different names or if the database name has changed. If the databases have the same name, the Map Fields dialog box does not appear, and you need to verify the database when you have finished setting the location. For more information, see Using the Verify Database process.

### Remapping altered database fields

Use the Map Fields dialog box to remap existing report fields in the active database if they have been altered.

###### To remap an altered database field

1. With the report active in the Design tab, choose `Verify Database` from the `Database` menu.

   The Verify Database message box appears.

   - If the program detects no changes in the active database, the message box displays this message: "The database is up to date." In this case, click OK and return to your work.
   - If the program detects a change(s) in the active database, the message box displays this message: "The database file ["database name"] has changed. Proceed to fix up the report?"
2. Click `Yes`.

   If the program detects that a field name has been altered in the active database, the Map Fields dialog box appears.

   Note: The program automatically adapts the report to changes in other data within the database (number of fields, field position, data type, etc.). It is not necessary to remap fields in which these changes have been made.

3. Highlight the first report field that you want to remap in the upper-left box.
4. In the upper-right box, highlight the unmapped database field to which you want to remap the selected report field.
5. Click `Map`.

   The highlighted report and database fields no longer appear in the upper boxes. Instead, they appear in the corresponding lower boxes.

6. Repeat Steps 3 through 5 for each unmapped report field you want remapped.

   Note: If the names of any report fields remain in the upper-left box when you exit the dialog box, the program removes them from your report.

7. Click `OK`.

   The program remaps the report fields to the altered database fields.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com