Creating the Vendor Table

You will now create the Vendors Table for the Order Entry sample application.

Step 1: Create a New Table

1. Click the Create New Table button on the Table Explorer toolbar.
2. In the Create New Table dialog, type Vendor as the Table Name and click OK.
3. The new table will open in the Table Editor.

Step 2: Add Columns

Add columns to the table schema until your column definitions look like those in the image below.

Next, you will add indexes for this table.

Step 3: Add Indexes

Index 1

1. Click on the Add Index toolbar button on the Index tab to add a new index.
2. In the Segments grid, select Id as the column to add as the first index segment from the combo box. This is the only segment for the first index, meaning that we will never be allowed to have two vendors with the same ID. This is what we want.
3. The completed index should look like this:

Index 2

1. Click on the Add Index toolbar button to add index 2. The segments of this index will be Name and Id.
2. The completed index should look like this:

Step 4: Save the Table Schema

1. Click the Save File toolbar button (or press Ctrl + S) to save the table schema.

The Output window will display the results of the save operation.
Note that a Data Dictionary is automatically created when you create a new table (when you save the table the first time).

Next Step

Creating the Order Header Table