Ask Your Question
0

Embedded "Table-in-table" View

asked 2018-07-01 21:46:45 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

In Microsoft Access you are able to see a "table within table" view. Was hoping this was possible in Base. Included a picture of what I mean.

You can see I have two tables. One is Artist and the other is Album. When I open the Artist table there is a plus sign that can expand and show the Albums from the Album table that match that Artist.

image description

I realize I could generate a report to get this type of view. However I like how in Access I can get this view in the normal table view so that I can add new entries right there and not have to swap between windows to see the report and then go somewhere else to add additional data.

edit retag flag offensive close merge delete

Comments

@BenBase Please do not post questions as wiki. It helps no one..

Ratslinger gravatar imageRatslinger ( 2018-07-01 22:00:24 +0200 )edit

Sorry, clicked the checkbox to see what the difference was and then forgot to uncheck.

BenBase gravatar imageBenBase ( 2018-07-02 02:15:05 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-07-01 22:04:24 +0200

Ratslinger gravatar image

Hello @BenBase,

This cannot be done in LO Table view. However it is simple enough to have a form containing the the Artist selection (table) with a subform containing the Album information.

For more information please refer to the LO Base documentation -> LibreOffice Base Handbook.

edit flag offensive delete link more

Comments

Thank you, will go about doing it that way.

BenBase gravatar imageBenBase ( 2018-07-02 02:15:41 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-07-01 21:46:45 +0200

Seen: 34 times

Last updated: Jul 01 '18