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

100

101

Figure 198: Selection of joined subform and main form fields

1) Select Date from the

First joined subform field

dropdown list.

This is the Date field in the Fuel table. This is not the Primary key

for the Fuel table, but it is known as a Foreign key.

2) Select Date from the

First joined main form field

dropdown list.

This is the Date field in the Vacations table. This is the Primary

key for the Vacations table. Click Next.

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.

Note

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 right are

Columnar left

Columnar - Labels on top

, As

Data Sheet

, and

In Blocks - Labels Above

(Figure 199).

Chapter 8 Getting Started with Base 259

1 2 ... 254 255 256 257 258 259 260 261 262 263 264 ... 432 433

Comments to this Manuals

No comments

OpenOffice.org OpenOffice - 3.0 Quick Start Guide Page 259

Comments to this Manuals

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