Now you will add a field to the screen with a different visualization. The Comments field in the Customer table is a text field that can get fairly long, but its default display (as defined in the Data Dictionary) is just as a fill-in. You can add it to the screen and then change it to an editor, which is a more appropriate way to display the information.

Before you go any further, you should change the query on the Customer table so that it does not just show New Hampshire Customers sorted by the City. In the Sports2020 database, most of the fill-in field Comments values are toward the beginning of the Customers, so to see meaningful data in the field you need to look at Customers toward the beginning of the table.

To edit the query on the Customer table:

  1. Double-click on the design window (outside of any field) to go into the property sheet for the frame.
  2. Click the Query button and edit the WHERE clause and the SORT phrase out of the query. You should know how to do this from using the Query Builder in Introduction to the OpenEdge AppBuilder.
  3. Exit the Query Builder and extend the design window to the right by dragging the window edge with the mouse, to make room for new fields.

To change the fill-in field to an editor:

  1. Click the DB Fields button in the AppBuilder Palette window:
  2. Click on an empty space on the right side of the design window.
  3. Select Customer in the Table Selector dialog box, then click OK.
  4. Add the Comments field in the Multi-Field Selector dialog box that appears, and then click OK.

    The field now appears as a long fill-in field in your design window. It is even possible you could get a warning message that the field is too long to allow the label to be displayed. That is not a problem, since an editor does not have a label anyway.

  5. With the Comments field still selected in the design window, open the Properties Window.
  6. Select the Type line in the display. This shows the current display type (Fill-In) in a combo-box at the top of the window.
  7. From the drop down menu, select Editor:
  8. Click the green check mark and close the window. Now your Comments field is an editor.