Getting Started Guide

Figure 207: Type of list contents dropdown
list
• Type the following exactly as it is in the List contents box:
SELECT "Type", "Type" FROM "Payment Type"
Figure 208: 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 209 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.
Chapter 8 Getting Started with Base 277
Free eBook Edition