Problem solve Get help with specific problems with your technologies, process and projects.

Modifying forms and creating data lists in OpenOffice

Office suite expert Solveig Haugland explains how to modify data via databases in OpenOffice.

I seem to be able to get about 50% of things right following your various tutorials concerning databases. However, what isn't so clear is how do you modify a form? What happens if you don't initially specify a key? How you create data lists (i.e. if I have a group of friends, and want to have a data field for all the cities they have lived in, and want to pull this data from a secondary table). Then again, I'm new to databases so I'm very much struggling in the dark.

The key question isn't so much about the form; it's about the database that the form is based on. If you create the database through OpenOffice.org you will be forced to create a key, so that's not a problem.

To modify a form, just open the database that it's based on, then click the Forms icon at the left side, and when you see the form name, right-click on it and choose Edit.

The form will open. Right-click on any component and choose Control or Form to modify it. You can also use the Form Controls toolbar.

Choose View > Toolbars > Form Controls, when you have the form open, if you don't see the toolbar.

To make the list you're talking about, I'm not enough of a database expert to do the table relations planning. However, you could set up a view between the two tables, the main and the secondary. See my article on views.

Then, modify the form and choose to replace the City field with a list box.

Right-click on the control and in the Data tab, specify the field to bring in the data from.

You could also just create a field with those cities in them. Create a list field using the Form Controls toolbar, and don't connect it to a table. Just right-click on it and choose Control. Then, in the window that appears, look for the List Entries field and just type your entries. See my article on modifying forms; there's a lot of detail in there about creating a hardcoded list field.

Dig Deeper on Linux servers

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.