Tutorial

Customizing what you see 27
3. Drag the Last Name field label above the Last Name field.
4. Drag the First Name field label above the First Name field.
5. Choose View menu > Browse Mode to see your results.
Add a field
If a field has been defined in a table, you can display it on any layout
based on that table. In this database, some defined fields are not on
this layout. You will add one of these fields now.
Note You can also place fields from other tables on your layouts, as
explained in Lesson 10.
1. Choose View menu > Layout Mode.
2. Using the Field tool, drag the field to the layout, and place it below
the First Name field.
3. In the Specify Field dialog box, select the City field.
4. Click OK.
5. Choose View menu > Browse Mode to see your field.
You see a city entered in each record. City data was entered
previously, and the field holds the data.
Display a number as currency
You can display a number as currency, even though only the number
is typed into the field.
1. Choose Window menu > Sample05.
2. Choose View menu > Browse Mode.
3. In the Fee Information layout, look at Fee Paid and notice that the
number displays as currency.
4. Click the number to see the data actually entered in the field.
Formatting affects only the way data is displayed. It does not change
the data.
5. Choose Window menu > MyFile05.
6. Choose View menu > Layout Mode.
7. Select the Fee Paid field.
8. Choose Format menu > Number.
9. Select options as shown in the following Number Format dialog
box.
10. Click OK.
11. Choose View menu > Browse Mode to see the formatted data.
Field tool
Drag the new field