To create a new connection to a target database:

1. In the Project Explorer, open the Database/ERP folder and then right-click on Connections.
2. Choose Insert from the shortcut menu.
3. In the Name field, enter the name that you want to use to reference the target database. You can create multiple database connections, but each connection must have a unique name.

4. In the Connection String field, click the browse button … to open a standard Data Link Properties dialog. Use the dialog to configure a connection string for the target database.
5. In the User Name and Password fields, enter an appropriate login for the target database. The login should already be created on the database server, and it should have enough privileges to read from and write to the database tables.
6. Click OK to close the dialog and save the connection configuration.
7. Right-click on the Database/ERP folder in the Project Explorer, and then click Insert on the shortcut menu.

8. Description field: Enter a description of the worksheet, for documentation purposes.
9. Status field: Enter the name of a numeric tag that will receive status codes for database operations during runtime
10. Completed field: Enter the name of a numeric tag that will be toggled when database commands are successfully executed.
11. Error Message field: Enter the name of a string tag that will receive detailed error messages, if errors occur during runtime.
12. Connection combo-box: Click to select a connection to the target database. All available connections are listed, as configured with the Database Connection dialog described above.
13. Type combo-box: Click to specify how the result set will be selected for the worksheet:
1. Table: Enter a table name and an optional filter condition. (The filter condition is equivalent to the SQL "Where" clause.) All rows of the table that match the filter condition are selected.
2. SQL: Enter a custom SQL "Select" statement.
14. Insert field: Enter any tag; when the value of the tag changes, a new row is inserted with the current values of the tags configured in the worksheet body.
15. Update field: Enter any tag; when the value of the tag changes, all rows of the result set are overwritten with the current values of the tags configured in the worksheet body.
16. Delete field: Enter any tag; when the value of the tag changes, all rows of the result set are deleted.