
Then you should have a form comparable to the one below. Add the title Database Form on step eight, and click Finish to close the wizard. You can choose a variety of alternative styles for your form, such as Beige, Orange and Ice Blue, on the seventh step. In the final few steps of the of the wizard you should select The form is to display all data option on step six. Select Columnar – Labels Left options for both the main form and the subform as in the shot below. On the fifth step, choose a suitable arrangement for the main form. Then click Next to move to the wizard’s fifth step. Click on the double arrow to add all the Setup Details table fields to the subform. Select Setup Details and Next to choose the fields for your subform. Click the Add subform and Subform based on existing relation options. On the next step you should click the Add subform check-box option. Click on the double arrow to select all the table’s fields, and select Next to go to step two. On the first step of the wizard click the drop-down list, and select the Software Details table. Then click on Forms > Use Wizard to Create Form to open the window below. Click Finish to open both the primary Base window and the software database.

From the Database Wizard window, select Open an existing database file and then select its file from the drop-down list below. Open the database, in Base, set up in the previous article. OpenOffice Base, like most database packages, has options with which you can set up database forms.

Of course, you can input software records directly into those database tables but it’s better to add a data entry form from which you can enter the records. In part one of our guide on how to setup OpenOffice Base database, we covered how you can set up the tables for a software database.
