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

Reply via email to