I have this table which I am trying to populate using forms.
The first form is used to enter information for the first half of the table. The second form is used to enter the second half of the table. User enters information on form #1 and saves the information (using save button). User then clicks on a button labelled 'Form 2'. This opens Form #2 (for the current record they are entering information on). User then proceeds to enter rest of the information to populate second half of the table and saves (using another save button on form #2).
What is the basic structure of the forms I need to create to enable this very basic functionality? Does anyone have a prebuilt macro script to enable a button to launch the record in the second form to enable the user to continue working on? I am trying to circumvent Base's inability to provide tabs.
Moderator: I have removed any known cross postings. Please do not lock this post. I am up against the wall and really really need a solution.
LibreOffice Base ver 6.0.7.3
Linux Mint 19.2 Cinnamon
Populate table using multiple forms
Populate table using multiple forms
LibreOffice 6.0 on Linux 19.2 Cinnamon
Re: Populate table using multiple forms
Cross posting is fine providing you make it known that you are doing it and link to the other site(s) where you have posted. That way no one covers ground that has already been covered in another site.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 25.2.5.2; SlackBuild for 25.2.5 by Eric Hameleers
---------------------
Apache OpenOffice 4.1.15
LibreOffice 25.2.5.2; SlackBuild for 25.2.5 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue]
Unexpected '{' on line 32
.Re: Populate table using multiple forms
You can store the current record's primary key in a separate table and link the 2 entry forms to that value.
Search this forum for "power filtering".
Search this forum for "power filtering".
Last edited by Villeroy on Tue Oct 15, 2019 7:48 pm, edited 1 time in total.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Populate table using multiple forms
Added some more buttons and a list box.
[Sync] syncronizes this form after the other has been changed by refreshing the main form.
[OK] refreshes the subform after the main form changed.
[Open] opens the other form.
[Close] closes this form.
The list box in the main form shows the availlable IDs.
[Sync] syncronizes this form after the other has been changed by refreshing the main form.
[OK] refreshes the subform after the main form changed.
[Open] opens the other form.
[Close] closes this form.
The list box in the main form shows the availlable IDs.
- Attachments
-
- split_form.odb
- another power filter
- (64.58 KiB) Downloaded 203 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice