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

100

101

made from the same table with a text label (Fuel Purchases), a list box

placed in PaymentType, and a graphic background.

Using the Wizard to create a form

We will use the Form Wizard to create two forms: CD Collection and

Vacations. The CD Collection form will be a simple form, while the

Vacations form will contain a form and a subform. We will create the

Vacations form with its subform and let you modify the CD Collection

form using the same process.

In the main database window (Figure 176), click the Form icon.

Double-click Use Wizard to Create Form to open the wizard (Figure

195). Simple forms require only some of these steps, while more

complex forms may use all of them.

Step 1: Select fields.

1) Under Tables or queries, select Vacations as the table.

Available

fields

lists the fields for the Vacations table.

2) Click the right double arrow to move all of these fields to the

Fields in the form

list. Click Next.

Figure 195: Form Wizard steps

Step 2: Set up a subform.

Since we have already created a relationship between the Fuel and

Vacations tables, we will use that relationship. If no relationship had

been defined, this would be done in step 4.

1) Click the box labeled

Add Subform

2) Click the radio button labeled

Subform based upon existing

relation

3) Fuel is listed as a relation we want to add. So, click Fuel to

highlight it, as in Figure 196. Click Next.

Chapter 8 Getting Started with Base 257

1 2 ... 252 253 254 255 256 257 258 259 260 261 262 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 257

Comments to this Manuals

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