OpenOffice.org OpenOffice - 3.0 Quick Start Guide download pdf (Page 249)

100

101

Figure 180: Primary key field

Click

Primary Key

in the context menu. This places a key icon in

front of

FuelID

Note

The primary key serves only one purpose. Any name can be used

for this field. It is not necessary to use

FuelID

as the name of the

primary key field. We have used it so we know to which table it

belongs by its name.

3) All other entries:

• Enter the next field name in the first column (

Field Name

column).

• Select the

Field Type

for each field.

– For

Date

use Date[DATE]. (Use the

key once to select it.)

– PaymentType uses Text [VARCHAR], the default setting.

– All other fields use Number [NUMERIC]. (Use the

key

once to select it.)

• Select the

Field Properties

(Figure 181).

Figure 181: Field Properties section

FuelCost

FuelQuantity

, and

Odometer

need changes in the

Field Properties section (Figure 181).

–

FuelQuantity

: Change

Length

to 6 and

Decimal places

to 3.

(Many fuel pumps measure fuel to thousands of a gallon in

the USA where I live.)

–

Odometer

: Change the

Length

to 10 and the

Decimal

places

to 1.

–

FuelCost

: Change the Length to 5 and Decimal places to 2.

Click the Format example button (Figure 181). This opens

the Field Format window (Figure 182).

Chapter 8 Getting Started with Base 249

1 2 ... 244 245 246 247 248 249 250 251 252 253 254 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 249

Comments to this Manuals

Related products and manuals for Graphics software OpenOffice.org OpenOffice - 3.0