Create a Relational Database
After you have created a relational connection, you can set up the database.
-
Open the
Add New Database window
by following these steps:
-
On
the
Project tab, in the
Configuration group, select
Project Settings
.
- Click the Databases tab to view the databases settings.
- Under Databases, click Add.
-
On
the
Project tab, in the
Configuration group, select
Project Settings
-
Start creating the database
by following these steps:
- In the Database Name field, type a name to identify the database.
- In the Database Type group, select Relational Database.
-
Click
OK.
The Properties window for the database appears.
- In the Connection field, select the relational connection that connects to the database.
- In the Table or View Name field, select the table or view you want from the list.
-
Click
Refresh to open or update
the data in the
Table Records area below.
The Table Records area provides a read-only preview of the first 50 records of the referenced table or view.
Note If there is a problem with either the Connection or the Table or View Name, an error icondisplays. Hovering over the icon provides more information about the specific error.
-
Click
OK to accept the changes.
The Properties window for the database closes.
- Optionally, click OK to close the Project Settings window.
- Save the changes to your project.