Can I create different screen views of tables?

Creating tables and queries

Can I create different screen views of tables?

Postby summerleas » Fri Jun 01, 2018 1:38 pm

I use FileMaker Pro, but I might need to make 3 data bases available to others, so using Base could be useful. The data bases are simple tables with no relationships. So selecting/searching should be easy. But I have a question due to ignorance of Base:

FileMaker separates layouts (lists, forms etc) from the data base. So I can create a “table” view on the screen that only contains selected fields and scroll through and search that. I can also have a forms “list” view where there are several forms on the screen and I can scroll through and search them easily seeing several at once. Can I create such layouts in Base? Either or both.

A simple example. A data base consists of about 27,000 names, locations, dates (years and months separately because of the source data, which is 18th and 19th century hand-written sales books), number of items etc. I need a display that includes only names and locations. I also need a display that includes only names and another field. Extremely easy to do in FileMaker Pro, but I have no idea how to do it in Base!
OpenOffice 4.1.5 on Mac OS 10.11.6
summerleas
 
Posts: 1
Joined: Fri Jun 01, 2018 12:48 pm

Re: Can I create different screen views of tables?

Postby Villeroy » Fri Jun 01, 2018 2:22 pm

summerleas wrote: I also need a display that includes only names and another field.

Insert>Query...
Code: Select all   Expand viewCollapse view
SELECT "Name", "Other Field" FROM "Somewhere"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can I create different screen views of tables?

Postby UnklDonald418 » Fri Jun 01, 2018 7:48 pm

A Base form document can display multiple forms each with a different data source (table or query). There are filtering options (queries) so the
view on the screen that only contains selected fields

SubForms are another feature than can help with searching and filtering.
OpenOffice user manuals can be found at:
https://wiki.openoffice.org/wiki/Documentation
Chapter 8 deals with Base and has a section on creating and maintaining Base forms.
There is also a lot of information that you might find useful at
[Example #1] Filter/Search with Forms (leveraging SubForms)
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the subject line
Apache OpenOffice 4.1.5 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 796
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Tables & Queries

Who is online

Users browsing this forum: No registered users and 1 guest