Design View

The Design view displays the details of the fields in the selected table and their properties. You can display it at any time by clicking the Design View tab at the bottom of the Data Builder window.

This view includes the following panes, which you can use to configure the properties for the table fields and to create validation rules.

Tables Pane

The Tables pane lists all the data tables and phrase libraries in the database. Click a data table to view its fields in the fields pane. To add or remove a data table, click Add or Remove on the Home tab.

When you right-click an existing item in the Tables pane, the following options are available:

Rename: Renames the selected item.
Remove: Deletes the selected item.

Add Phrase Library: Adds a new phrase library to the database.
Add Data Table: Adds a new data table to the database.

Cut: Cuts the selected item and places it on the Clipboard.
Copy: Copies the selected item and places it on the Clipboard.
Paste: Pastes the item from the Clipboard.

You can use the cut, copy, and paste features to move or copy tables and libraries from the current database in the current instance of Data Builder to another database in another instance of Data Builder.

Import Data Table: Starts the Import Table wizard so that you can import data tables from an external database. For more information, refer to Importing and Exporting Data Tables.
Import Phrase Library (CSV): Starts the Import Phrase Library wizard so that you can import a phrase library in comma-separated value (CSV) format. For more information, refer to Importing and Exporting Phrase Libraries.
Import Phrase Library (TMX): Starts the Import Phrase Library wizard so that you can import a phrase library in Translation Memory Exchange (TMX) format. For more information, refer to Importing and Exporting Phrase Libraries.

Export CSV: Opens the Select CSV File Name dialog so that you can save the selected table as a CSV file.

Fields Pane

Field Properties Pane

The Field Properties pane displays the properties for each field in the selected table. You can edit these properties, create or edit a validation rule, and create a validation error message. When you click a property, a description appears in the right side of the pane.

Depending on the data type of the selected field, the following options are available:

Format: Specifies the format of the data in the field. The available formats depend on the field's data type.
Default Value: Specifies the default value of the selected field.
Auto Number Start Value: Specifies the start value. Available for the auto-incrementing ID data type.
Auto Number Increment: Specifies the increment interval. Available for the auto-incrementing ID data type.
Field Size: Specifies the size of the field. Available for the text data type.
Choices: Specifies the choices that you want to be available for the field when you are entering data. Click Choices to open the Enter / Edit Choices dialog, where you can specify the choices that you want. Available for the multiple choice data type.
Indexed: Specifies that the Indexed property for the selected field is set to True (when selected) or False (when not selected).
Required: Specifies that the Required property for the selected field is set to True (when selected) or False (when not selected).
Unique: Specifies that the Unique property for the selected field is set to True (when selected) or False (when not selected).
Validation Error Message: Specifies an optional error message that will appear to the user if the database is not valid.
Validation Rule: Specifies a rule that is used to validate the data. To edit this rule, either click in the Validation Rule field or click to open the Edit Validation dialog.