Map Fields Dialog Box
The Map Fields dialog box is used to link report fields to their corresponding database fields when changes are made to the structure of the database, or when moving a database from a direct access type to an SQL type. The Map Fields process helps you to make sure your reports print with the current version of the active database.
This dialog box appears when you click Update in the Set Datasource Location dialog box, or if the report database has changed since you last ran the report.
| Unmapped fields (report fields) | The Unmapped fields list (upper left) shows the unmapped report fields for which the program detects a change in the active database. |
| Unmapped Fields (database fields) | The Unmapped fields list (upper right) shows the unmapped database fields for which the program detects a change. |
| Map | Click Map to map the report field selected in the Unmapped fields list (upper left) to the database field selected in the Unmapped fields list (upper right). |
| Match type | When the Match Type check box is selected, the Unmapped fields list (upper right) shows only the names of unmapped database fields that are of the same type as the field selected in the Unmapped fields list (upper left). When the Match Type check box is not selected, the Unmapped fields list (upper right) shows all unmapped database fields, regardless of the field type. |
| Mapped fields (report fields) | The Mapped fields list (lower left) displays the names of mapped report fields. When you map report fields, those fields appear in this list. |
| Mapped fields (database fields) | The Mapped fields list (lower right) shows the mapped database fields. When you map database fields, those fields appear in this list. |
| Unmap | Click Unmap to unmap the report field selected in the Mapped fields list (lower left) and the database field selected in the Mapped fields list (lower right). After you click this button, the two fields are longer mapped. |