Getting Started Guide

• Type the following exactly as it is in the List contents box:
SELECT "Type", "Type" FROM "Payment Type"
Figure 200: List content for payment type fields
Note
What you wrote is called an SQL command. The words SELECT and FROM
are written in capital letters because they are commands. When the
command SELECT is used, it requires a field name within quotation marks
and then the field’s alias, also within quotation marks. In this case, the
field and its alias are the same. The FROM command requires the name of
the table which contains the field. Single-word table names do not require
quotation marks, but multiple-word table names do.
• Repeat these steps for the payment fields for Lunch, Supper, Motel,
Snacks, and Misc. The main form should look like Figure 201 as far as
where the controls are located. It also shows what the Note control should
look like. Those changes are explained in the next step.
• Close the Properties window.
Figure 201: Position of controls in main form
Step 7: Change the Misc. Notes field.
We want the Misc. Notes control, which has a field type of Memo, to have a vertical
scrollbar for additional text space if desired.
1) Control+click the Misc. Notes field. The green handles should surround the
field but not its label.
224 Getting Started with OpenOffice.org 3.3