Building a Data Retrieval Application

In this lesson, you'll use an editor to add your tables and fields, and connect them to the Tutorial database created in the introduction.

1. From the toolbar, place a Connector object on the Home page. This will establish a connection to Tutorial.

The Connector Properties palette will appear.

2. In the Connector Properties palette, type Tutorial the Data Source Name as named in the Introduction.

Complete the additional fields in the Connector Properties palette, if necessary (ex. User and Password, if required).

Next, you will need to set up the tables and fields.
 

3. Double-click to open the Schema Editor.  On the DB Schema tab:
    

1. Type Employees in the Table Name field and press Enter.
    

2. Type FirstName in the Field Name field, then click Add.
    

3. To add the remaining datafields, repeat Step 3b for LastName, Email, Phone, Department, and Location. 

4. Click OK to close the Schema Editor.

Now that you have added your table and datafields, you are ready to query the database for the employee records.