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

100

101

• Double-click the name of the table. In our case, do this for

both Vacations and Fuel.

• Or, click the name of the table and then click Add for each

table.

3) Click Close to close the Add Tables dialog when you have added

the tables you want.

4) You can define the relationship between the Vacations and Fuel

tables in two ways:

• Click and drag the Date field in the Fuel table to the Date field

in the Vacations table. When you release the mouse button, a

connecting line forms between the two date fields (Figure 191).

Figure 191: Designation for a 1:n relationship

• Or, click the New Relation icon. This opens the Relations

window (Figure Error: Reference source not found). Our two

tables are listed in the Tables involved section.

– In the Fields involved section, click the dropdown list

under the Fuel label.

– Select Date from the Fuel table list.

– Click in the cell to the right of this dropdown list. This

opens a dropdown list for the Vacations table.

– Select Date from the Vacations table list. It should now

look like Figure 192.

– Click OK.

Figure 192: Selected fields in a relationship

Chapter 8 Getting Started with Base 265

Free eBook Edition

1 2 ... 260 261 262 263 264 265 266 267 268 269 270 ... 441 442

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 265

Kommentare zu diesen Handbüchern

OpenOffice.org OpenOffice - 3.2 Schnellstart Anleitung Seite 265

Kommentare zu diesen Handbüchern

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