To perform data I/O, you need to link internal data fields to external data fields. You can link the fields using a mapping view. To open the mapping view, you will use the Field Mapping property available in the "General" tab of the Data I/O Settings properties.Displaying a Mapping View
- Select [File] - [Data I/O Settings] from the menu. The Data I/O Settings table is displayed.
- Select the table from the list for which you want to link fields. In the properties window, properties of the format of the table you selected are displayed.
- Select the "General" tab.
- Click the [...] button for the "Field Mapping" property. A mapping view for the table you selected is displayed.
A mapping view displays the list of internal data fields on the left and the list of external data fields on the right of the window. The scroll bar on the right edge is available for scrolling the external data fields list vertically and the scroll bar on the left edge is for scrolling the internal data fields list vertically.
You can link fields according to the following operations.
- Place the mouse cursor on one of the internal properties for which you are going to link an external field.
- Hold down the left mouse button and move the mouse cursor to one of the external fields to which you want to link the internal field. If you want to add a new field to the external data fields list and link an internal field to that field, move the mouse cursor to the bottom of the external data fields list where a new field is available.
- Release the left mouse button.
The two fields that have been linked are connected by a line.
Changing the Field Linkage
You can change the field linkage according to the following operations.
- Place the mouse cursor on one of the lines that connect fields for which you want to change the linkage.
- Click the left moue button to select the line. Clicking on the left half part of the line enables you to change the linkage of internal property and clicking on the right half part of the line enables you to change the linkage of external field.
- Move the mouse cursor to the target field and release the left mouse button.
Right-clicking the mouse on the middle part between the internal and external fields lists displays a popup menu.
Deletes the line you selected.
Deletes all the linkage.
Automatically links the internal properties and external fields that have the same name.
Automatically links the internal properties and external fields that exist at the same position.
Restores the default field mapping.
Applies the currently specified field linkage. Whenever you change the linkage, make sure to execute [Apply] after making the change. If you fail to execute the [Apply] command, the change you have made will not be effective. If you try to close the mapping view without executing the [Apply] command, a confirmation message will appear. If you click the [OK] button, the change you have made will be effective and applied.
Internal Property Popup Menu
If you select an internal property by clicking the number of that property and then click the right mouse button, a popup menu is displayed.
Clicking "Primary Key" will set the property you selected as a primary key. If the property has already been specified as a primary key, clicking "Primary Key" cancels the setting. "Primary Key" represents a key field(s) for merging internal data when external data is imported.
External Field Popup Menu
If you select an external properties by clicking the number of that property and then click the right mouse button, a popup menu is displayed.
Deletes the field you selected. If the field is linked with an internal property, the linkage will also be deleted. This is valid only when the data source is a text file.