Re: [libreoffice-users] user interface to Base

Hi Bob,

I haven't played much with Base, but there are at least two ways of
viewing the stored information that I know of.

The first is to create a form. I know you can set the form so that you
cannot add, modify or delete any data, which in effect means the form
will be for viewing only.

The second way is to create a report. It really depends on what you
want people to be able to see as to which would suit you better. Forms
are more for viewing a single table one record at a time, whereas
reports are more for generating a listing of information from the
database, possibly from multiple joined tables, and usually only a
subset of the data for each record (but again that depends on how much
data there is), and possibly grouped, with subtotals and stuff.

Play a little and see if one of these two don't meet your needs,
otherwise feel free to provide a little more details about what you
want to achieve and someone here might come up with a better way.

Of course there are other ways outside of LO, like custom frontends,
possibly web frontends, but I'm not sure if you need that sort of
thing.

Paul



On Thu, 5 Dec 2013 14:25:35 -0500
"Bob Muir" <rmuir2@triad.rr.com> wrote:

> Hi all,
> I am a new user of LibreOffice Base and a beginner in database
> creation.
>
> I believe that I have figured out how to create my simple database of
> tables and forms.
>
> My question is "Is there a friendly, visual (GUI) thing for
> retrieving information from the database?"  I don't want to  require
> anyone to write SQL code or use the query design view provided by
> Base.
>
> It is possible that the database might be placed on a web server if
> that makes a difference.
>
> Thanks,
>
> Bob


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted