![]() ![]() While working through the wizard, user choices are reflected in the document. Thus all of the power of Writer - think Word - are available in setting up a form. Of interest is that forms are actually set up in Writer, the word processing module. With only a few hours of experimentation under my belt, I cannot be certain but what multi-table queries are read-only in Base. The above query, joining two tables, was read-only. This query is based on a single table and is editable. The design window can be hidden or shown while the query is running. ![]() Running the query produces a split-screen effect. If not, then a graphical grid interface allows queries to be set up, including grouping queries using the function field. One has the option of writing SQL statements should one be in the mood. Double-clicking on the join allows one to set a left or right join. The relations design dialog box is drag and drop to set up a inner join. Relationships can be set up from the relationships dialog box, tables are added as needed. Where choices are limited, OpenOffice is very helpful with drop down lists. The typo in the word "numer" is strictly my own! A right-click on a unique field allows one to set a primary key. Setting up tables in the design view is direct and aided by OpenOffice automatically entering the IDENTITY command for a field set to AutoValue automatically. OpenOffice is always open to interacting with other vendors products. A wizard gets one started, allowing choices of whether to utilize an embedded database or whether to use a connector to another vendors database. ![]() The basic interface is rather reminiscent of Microsoft Access. The database package is now relational and replete with tantalizing features. October 2005 saw the arrival of Release Candidate 1 and the fifth birthday of OpenOffice. By March 2005 the branch adopted the OpenDocument standard, and in early fall betas one and two were released. The first iterations of the database in December 2004 were simple flat files with little additional functionality beyond a spreadsheet. When the 2.0 branch forked, I began playing with the pre-release 1.9 versions. Since 19 January 2003 when I first started using OpenOffice I have moved into the newest builds. That's no typo: OpenOffice remains free for the downloading - Windows, OS X, and Linux. The increase in price from $0 to $0 is made quite tolerable by this addition. To this winning mix OpenOffice 2.0 adds a database. Re-open the has always been cross-platform with a word processing module the equal of Microsoft Word called Writer, a spreadsheet that is nearly indistinguishable from Excel in capabilities, a presentation module that has all the capabilities of PowerPoint, and three other modules that Office has never offered: a WYSIWYG web page editor, a stand-alone math editor, and a drawing package with dozens of export options. Line count… select the number of your text values. Scrool down to find Dropdown… select yes. Here you can change various appearance and functionoptions, but here we are concerned with a few options towards the lower end. On the next entry “List content”, type in your desired text values. On the entry “Typeof list contents” select “Valuelist”. On the “Data” tab and the entry “Data Field” select one of the columns of the table connected to your form. The Properties dialog box for that control appears. Righ-click on the field and select Control… Select from the Form Controls toolbar (on the left by default) the List box and drag on the form for the desired location of your field. You have created one form, and specified the aforementioned table (create any control, right-click on the Control select Form…, specify table on the Data tab). If I understand your question correctly, you wish for a control where the user of the form has to input one of several predefined values, and this value inserted into a table column of the underlying database, correct? Then the actual feature is not one concerning the table or its fields, but the Form and its controls, AFAICTįor a start I presume you have created a table with the appropriate columns and correct data types. ![]()
0 Comments
Leave a Reply. |