User manual

118 | Creating databases
To choose a field in another table, choose the table from the table list above
the list of fields. Then select a field from the fields list. Or choose Manage
Database in the table list to create a relationship or table (see
“Creating
relationships” on page 145).
4. To include the field name as text on the layout, select Create label.
5. Click OK.
You see the field name in the field on the layout unless you have chosen to
display sample data from the current record (by choosing View menu >
Show > Sample Data). Fields from related tables appear as ::Field Name
(preceded by two colons).
To replace a field with another, in Layout mode, double-click the field, then
select another field name in the Specify Field dialog box and click OK.
To remove a field from a layout, in Layout mode, click the field to select it, then
press Backspace or Delete, or choose Edit menu > Clear. Removing a field from
a layout does not delete the field or its data from your database.
Setting up checkbox sets and other controls on a layout
You can format fields to display as drop-down lists, pop-up menus,
checkboxes, radio buttons, and drop-down calendars. You can also format
fields to auto-complete by suggesting possible matches as the user types data
in the field. All of these options aid in data entry.
To set up a field to display a pop-up menu, checkbox set, or other control:
1. In Layout mode, double-click the field (or select the field and choose Format
menu > Field/Control > Setup).
1 If the field isn’t already on the layout, click the Field/Control tool and
drag the crosshair pointer to add a field object to the layout. Then, in the
Field/Control Setup dialog box, specify the field you want in the Display
data from area.
1 If the field hasn’t been defined yet, choose File menu > Manage
Database to define a new field.
φμπ10_υσερσ_γυιδε.βοοκ Παγε 118 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ