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.
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.