OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung PDF herunterladen (Seite 269)

100

101

5) Click Next.

Figure 198: Selecting fields of a subform

Step 4: Get joined fields.

This step is for tables or queries for which no relationship has been

defined. Because we have already defined the relationship, the wizard

skips this step.

Note

It is possible to create a relationship between two tables that is

based upon more than one pair of fields. How to do that and

why is discussed in the Base Guide.

Caution

When selecting a pair of fields from two tables to use as a

relationship, they have to have the same field type. That is why

we used the Date field from both tables: both their field types

are Date[DATE].

Whether a single pair of fields from two tables are chosen as

the relationship or two or more pairs are chosen, certain

requirements must be met for the form to work.

• No field from the subform can be the Primary key for its table.

(FuelID cannot be used.)

• Each pair of joined fields must have the same file type.

• One of the fields from the main form must be the Primary key

for its table. (Date would have to be used.)

Step 5: Arrange controls.

Each control in a form consists of two parts: label and field. This step

in creating the form determines where a control’s label and field are

placed in relationship with each other. The four choices from left to

Chapter 8 Getting Started with Base 269

Free eBook Edition

1 2 ... 264 265 266 267 268 269 270 271 272 273 274 ... 441 442

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 269

Kommentare zu diesen Handbüchern

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 269

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Grafiksoftware OpenOffice.org OpenOffice - 3.2