a) Right-click the line connecting the Date fields in the two table
lists to open a context menu.
b) Select Edit to open the Relation window (Figure 192).
c) Select Update cascade.
d) Select Delete cascade.
Figure 192: Update options and Delete options section
While these options are not absolutely necessary, they do help. Having
these options selected permits you to update a table that has a
relationship defined with another table. It also permits you to delete a
field from the table.
Creating a database form
Databases are used to store data. But, how is the data put into the
database? Forms are used to do this. In the language of databases, a
form is a front end for data entry and editing.
Figure 193: Fields of a simple
form
Figure 194: Simple Form with
additions
A simple form consists of the fields from a table (Figure 193). More
complex forms can contain much more. These can contain additional
text, graphics, selection boxes and many other elements. Figure 194 is
256 Getting Started with OpenOffice.org 3
Comments to this Manuals