Getting Started with Open Office .org 3 part 26. This Manual Book is for anyone who wants to get up to speed quickly with the latest version . “GETTING STARTED WITH ″ introduces all software programs of the OpenOffice bundle: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector drawings), Math (equation editor) and Base (database). This book was written by volunteers from the community working through and is distributed under the CreativeCommon Attribution Licence | Figure 183 Example of Description entries Creating tables for the list box When the same information can be used in several fields design a table for each type of information. Each table will contain two fields the information field and ID in this order. Caution You must create these tables with the information field listed first and the and the ID field listed last. Failure to do so will produce the wrong results. For my Payment table I use Name and ID as my fields with Dan Kevin and Cash being the Name entries. The corresponding ID entries are 0 1 2. When the Name field is listed first in the table one of the three names will appear in the payment field of the Fuel table. If the ID field is listed first 0 1 or 2 appear in the payment field instead. 1 Follow the directions in Creating tables in Design View on page 248. In the table we will create the two fields can be Type and PaymentID. Make sure that the AutoValue is set to Yes for the PaymentID field. Set the PaymentID field as the primary key. See Figure 184. 2 Save the table using the name Payment Type. Chapter 8 Getting Started with Base 251 Field Name Field Type Type Text VARC HAR PaymentID Integer INTEGER Figure 184 Table in Design View Note If you have several tables to create with the same fields design one table and produce the other tables by cutting and pasting. See Creating a table by copying an existing table on page 247. Adding data to the list table List tables do not require a form. Instead add their data directly to the table. In this example use the names of the two people with a bank card and Cash for cash purchases. 1 In the main database window click on the Tables icon Figure 176 . Right-click on Payment Type and select Open from the context menu. a Enter Dan in the first row. Use the tab key to move to the second row. b Enter Kevin in the second row. c Enter Cash in the third row. 2 Save and close the table window. The Enter key can also be used to move from field entry to field entry. For
