OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido descargar pdf (Pagina 214)

• 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 183).

Figure 183: Designation for a 1:n relationship

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

(Figure 184). 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 184.

– Click OK.

Figure 184: Selected fields in a relationship

5) Modifying the Update options and Delete options section of the Relation

window.

a) Right-click the line connecting the Date fields in the two table lists to open

a menu.

b) Select Edit to open the Relations dialog (Figure 185).

c) Select Update cascade.

d) Select Delete cascade.

214 Getting Started with OpenOffice.org 3.3

1 2 ... 209 210 211 212 213 214 215 216 217 218 219 ... 378 379

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía de inicio rápido Pagina 214