## Adding tables to a dictionary

### Adding a data file

1. While in the Crystal Dictionary Expert, click the Tables tab.

2. Click the `Data File` button.

   The Choose Database File dialog box appears.

3. Use the options in this dialog box to highlight a database file.
4. Click Add to add the file. If the selected database file contains only one table, that table will appear in the list box on the Tables Tab.

   Note:

   - When there is more than one table to add from the selected database file, the Select Tables dialog box appears. Highlight the tables you wish to include from the list and click OK. Only the tables you selected will appear in the list box on the Tables Tab. See Designing the view of the data.
   - You cannot create a dictionary from two different data sources.
5. Repeat Steps 3 and 4 for each database file you want to add to the dictionary.
6. Click Done when you are finished adding database files.

   Note: When a database file is added, the tables and fields from that file will not necessarily appear to the user who opens the dictionary from the Report Designer. The tables that appear on the Tables Tab are only the tables available to the creator of the dictionary. To add specific fields, see Designing the view of the data.

   You may also need to choose an index file to be used by one of the database tables. This is done on the Tables Tab:

7. Highlight the database table you want to pick a specific index for.
8. Click the `Index` button.

   The Choose New Location dialog box appears.

9. Use the controls in this dialog box to highlight a new index file, and click OK when finished.

   Note: By default, Crystal Dictionaries will use any index file it finds with the same name as the database file. You only need to select an index file if you want to use an index with a different name than the database file.

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