How to add a table
Further expand a by adding tables to it.
To add a table
- On the Model menu, select Add Database Object, and then select Add Table.
- For each new field, enter the name in the Field Name column, select the Data Type, and enter an optional Caption.
- To choose the fields that constitute the primary key, select the field, right-click on the far left gray column for that field, then and choose Primary Key.
To select multiple fields at once, press CTRL and click in the far left gray column for each field.
- On the Basic tab, select or enter the options desired.
Note The available options vary with the Data Type chosen.
- Click the Advanced tab and set or change the options related to Null values, denormalization, and aggregation.
- When finished setting the options, click OK.
The table is created with a default name.
- On the SQL tab, right-click the new table, click Rename.
- Enter a name for the table and press ENTER.
See Also
Advanced Tab (Table/New Table Dialog Box)
Basic Tab (Table/New Table Dialog Box)
Model Editor
SQL Tab (Model Editor)
Table/New Table Dialog Box