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.
-
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.
Connection or the Table or View Name, an error icon displays. Hovering over the icon provides more information about the specific error.If there is a problem with either the -
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.