Form for inserting data to table from fields

Creating and using forms

Form for inserting data to table from fields

Postby arrowman » Sun Jun 10, 2018 9:44 pm

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?
Attachments
Form_insert.png
OpenOffice 3.2.1, Windows XP/Vista
arrowman
 
Posts: 8
Joined: Mon Nov 21, 2011 12:01 pm

Re: Form for inserting data to table from fields

Postby Villeroy » Sun Jun 10, 2018 10:27 pm

Yes, it is possible
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26248
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Form for inserting data to table from fields

Postby UnklDonald418 » Mon Jun 11, 2018 5:10 am

Look here for User Guides for AOO 3.2
https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/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)..
Attachments
Demo18A_Characters.odb
(120.87 KiB) Downloaded 36 times
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.1.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1030
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA


Return to Forms

Who is online

Users browsing this forum: Exabot [Bot] and 1 guest