Page 1 of 1

Form for inserting data to table from fields

Posted: Sun Jun 10, 2018 9:44 pm
by arrowman
I would like to create form for inerting data to table but from fields in form. Additionally it should have categories list which shows categories names from Category table but it would insert to Products category ID, not name.
I would like to read data from field in form and add these values into table.

Is this possible in Libreoffice/Openoffice base?

Re: Form for inserting data to table from fields

Posted: Sun Jun 10, 2018 10:27 pm
by Villeroy
Yes, it is possible

Re: Form for inserting data to table from fields

Posted: Mon Jun 11, 2018 5:10 am
by UnklDonald418
Look here for User Guides for AOO 3.2
https://wiki.openoffice.org/wiki/Docume ... s/Chapters
See Ch8 - Getting Started with Base has a chapter on creating forms. Also, look in the Tutorials and Examples areas of this Forum.
I included a simple demonstration database with 2 forms that both use a ListBox to display/select a category (Studio)..