Ask Your Question

Expandable/collapsible tree view

asked 2020-11-21 17:46:27 +0100

donac gravatar image

Hello, I'm trying to create my CD music database with LibreOffice Base, but I'm just a beginner with Base. What I would like to make is essentially a one-to-many relationship: one Album has many Traks. I've been able to create the database and a relationship between the two tables Albums and Tracks. What I couldn't figure out is how to obtain an expandable/collapsible tree view of the Albums list, so that by clicking on an Albums title would expand the Album title and show all the Tracks belonging to that Album. I've been able to make such a tree view on MS Access: every Album title has a + sign, so that, when I click on it, it expands and shows its Tracks. Is such a view possible in LibreOffice Base?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-11-21 23:48:12 +0100

Ratslinger gravatar image


There is no + in Base to show linked records.

You can have a form with albums as the main form and a sub form containing the tracks of the album. If set correctly (link main and sub form), selecting an album will then display the tracks linked to it.

The main form can be just about any type of controls you want - table, list box, or other individual controls.

edit flag offensive delete link more


Thank you very much! That solved my problem.

donac gravatar imagedonac ( 2020-11-22 06:35:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-11-21 17:46:27 +0100

Seen: 25 times

Last updated: Nov 21