OpenOffice Tutorial: Create a new table relationship
- To add table relationships, first click on the "Tables" icon here.
- Next, click on Tools.
- Then, on the menu that opens click on "Relationships..."
- You will then be asked to add the tables that you want to put relationships in. Just double-click on the table names to add them. Afterwards, click on "Close."
- As you can see, the three tables and their fields can be found here.
- Now, look for the first field that you want to establish a relation with and click and hold the left mouse button over its name.
- Then while holding the button, move your mouse towards the field of the other table to establish the link between the fields.
- Great! You should see a line representing the relationship of the fields and tables.
- Just repeat the process if you want to establish more relationships.
- Take note that you can drag the tables with their fields to clearly see the connections between them.
- If it gets hard to see the relationships between tables, you have the option to move the tables to see the connections clearly.
- Just click and hold the left mouse button over the table's name and then drag the table to a new position.
- Now, just release the mouse button to place the table in that location.
- As you can see the lines representing the relationships of the tables are still preserved and can be seen clearly. Just continue moving tables until you are satisfied.
- Once done, save the changes you have made by clicking here on the save button.
- Afterwards, just close the window by clicking on this "X" icon.
- Congratulations! You have learned how to create new table relationships.
by Kaj Kandler
Create a new table relationship
This screencast demonstrates how to create a new table relationship. You learn:
- How to open the relationship design view.
- How to add tables in the relationship view.
- How to establish a relationship between two fields in different tables.
- How to move tables in the relationship view.
- How to save the table and field relationships.
For advanced functionality with similar results see:
OpenOffice.org™ is a registered trademark of Oracle.
LibreOffice™ is a trademark of The Document Foundation.
Windows® is a registered trademark of Microsoft Corporation in the United States and other countries.