OpenOffice.org OpenOffice - 3.0 Guia de Início Rápido descarregar pdf (Página 251)

100

101

Figure 183: Example of Description entries

Creating tables for the list box

When the same information can be used in several fields, design a

table for each type of information. Each table will contain two fields:

the information field, and

in this order.

Caution

You must create these tables with the information field listed

first and the and the ID field listed last. Failure to do so will

produce the wrong results. For my Payment table, I use

Name

and ID as my fields, with

Dan

Kevin

, and

Cash

being the Name

entries. The corresponding ID entries are

0, 1, 2

. When the

Name field is listed first in the table, one of the three names

will appear in the payment field of the Fuel table. If the ID field

is listed first,

0, 1,

appear in the payment field instead.

1) Follow the directions

in “Creating tables in Design View” on page

248. In the table we will create, the two fields can be

Type

and

PaymentID

. Make sure that the

AutoValue

is set to Yes for the

PaymentID

field. Set the

PaymentID

field as the primary key. (See

Figure 184.)

2) Save the table using the name

Payment Type

Chapter 8 Getting Started with Base 251

1 2 ... 246 247 248 249 250 251 252 253 254 255 256 ... 432 433

Comentários a estes Manuais

Sem comentários

OpenOffice.org OpenOffice - 3.0 Guia de Início Rápido Página 251

Comentários a estes Manuais

Manuais e produtos relacionados com Software gráfico OpenOffice.org OpenOffice - 3.0