Once again, Girvin, I am very grateful to you's and Brian's patience and help.
I will try your methods tomorrow when I am not so frustrated!
I noted while stumbling around yesterday that I manage to open a screen that
looked just like the table of the database but larger and clearer. If this is a
screen that I can be changed and data added or removed it might be as useful as
a form. Was it another Table View?
Just that one more question and I will shut up and leave you alone.
Patrick A. Tillery
Note: Please keep all replies attached for reference--
-----Original Message-----
From: Girvin Herr [mailto:ghe...@fastmail.com]
Sent: Thursday, January 6, 2022 1:50 PM
To: users@openoffice.apache.org
Subject: Re: OpenOffice database and forms
Welcome to fun with AOO Base, ptillery!
You need to get the form into edit mode by right-clicking on the form
name in the main Base window and selecting "Edit". Then you may need to
open the form properties window by clicking on the "Form" icon (3rd one
down from the arrow icon on the left toolbar). This should open a "Form
Properties" window. Make sure the "Data" tab is selected and "Content
type" is set to "Table". Then under "Content", select your table. Now
your form should be linked to your table. Then you may have to associate
your form controls with a specific field in your table.
Take a look at the AOO Base section, Chapter 8, in the Getting Started
Guide at:
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Chapters
Being a Getting Started Guide, it is not fully detailed, but it may
answer your questions going forward. If that does not answer your
questions, another resource is the LO Base Handbook at:
https://documentation.libreoffice.org/en/english-documentation/
The LO manuals are pretty close to the AOO functions. I would suggest
you start with the LO 4.0 Base Handbook at the bottom of this page
rather than the latest and greatest LO 7.2 version at the top. The older
version may be closer to the current AOO version but without the
additional confusing features of the latest LO version of Base.
Another option I use a lot is to create a form query and associate my
form to that query instead of directly to the table. Use of the query
allows additional form features such as sorted lists in the form,
functions such as summing fields to get totals, etc. There is also the
"Sub-Form" option, but I do not have any experience with that feature,
so I cannot comment on it.
A note on Base Reports. As far as I know, AOO still does not have a
working report generator. Some people have had success with the Oracle
Report Builder extension, but I have not had any success with it on
version 4.x. LO does have a working built-in report generator and I keep
LO around only to do my database reports. I can imagine your next
question: why don't I use LO for everything? Plug: Contrary to some
others, I found that AOO is much more stable than LO. Features on LO
fail while the same or similar features on AOO just work reliably.
Apache seems to be doing a much better job at producing a stable
release. IMO: LO seems to be focused more on trying to keep up with the
latest from Redmond.
HTH.
Girvin
On 1/5/22 2:05 PM, ptillery wrote:
> I am a total Newby so please forgive my dumb question. I figired out how to
> build a simple database which I have been using in table mode for years. I
> got over confident and decided to start using a form. I built one in the data
> base. Now how do I get them together?Thank you!Sent from my Galaxy
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
