Buttons to open forms of same records

Discuss the database features

Buttons to open forms of same records

Postby biarced » Sun Oct 13, 2019 10:33 pm

Hello all:
Newbie here.
This has been a very useful forum to get initiated with Linux Mint in general and OpenOffice Base in particular.
I took up this project to help someone to record and present patient information and seem to have hit a wall. Any help will be highly appreciated.

Here's my situation:
I have this table with 200+ fields. In order to make it user-friendly, I decided to split the input process into various forms.
So, lets say, for the sake of simplicity, I have this table (T1) with fields F1, F2, F3, F4, F5 ... F200. (Key field is PatientID)
Form_1 houses F1 through F10
Form_2 houses F11 through F20
User populates Form_1 and clicks a button to take her to Form_2.
I would like the system to take her to Form_2 for the PatientID that she is working on in Form_1.
To elaborate: Lets say user entered her 15th patient record (PatientID = 15). When she was to click on the (Next) button, how can she access Form_2 for PatientID = 15?
Is there a macro I could use to initiate the button to take the user to the PatientID directly?
Last edited by floris v on Sun Oct 13, 2019 10:46 pm, edited 1 time in total.
Reason: Removed Issue icon, floris v, moderator
LibreOffice 6.0 on Linux 19.2 Cinnamon
biarced
 
Posts: 4
Joined: Sun Oct 13, 2019 9:51 pm

Re: Buttons to open forms of same records

Postby floris v » Sun Oct 13, 2019 10:45 pm

Welcome to the forum. Please update your signature. OpenOffice 6.0 doesn't exist, you may have LibreOffice. In some cases the version of the software really helps to pin down (the cause of) problems, so it helps if you provide that information right away. To do so, click User Control Panel (in the blue area of the page), select the Profile tab and then select Edit Signature (left pane).
AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4190
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Buttons to open forms of same records

Postby biarced » Sun Oct 13, 2019 10:52 pm

floris v wrote:Welcome to the forum. Please update your signature. OpenOffice 6.0 doesn't exist, you may have LibreOffice. In some cases the version of the software really helps to pin down (the cause of) problems, so it helps if you provide that information right away. To do so, click User Control Panel (in the blue area of the page), select the Profile tab and then select Edit Signature (left pane).


Ok. Updated signature.
LibreOffice 6.0 on Linux 19.2 Cinnamon
biarced
 
Posts: 4
Joined: Sun Oct 13, 2019 9:51 pm

Re: Buttons to open forms of same records

Postby Ratslinger » Mon Oct 14, 2019 12:33 am

LibreOffice 6.1.3
OpenOffice 4.0.1
Ubuntu Mate 18.04
Mint 18.3
Ratslinger
 
Posts: 22
Joined: Sun Mar 01, 2015 3:34 am

Re: Buttons to open forms of same records

Postby floris v » Mon Oct 14, 2019 11:33 am


Thank you. I will lock this thread.
@biarced: crossposting, as postinb the same question on two or more locations without saying so, is considered as very bad manners.
AOO 4.1.6 op Linux Mint
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 4190
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands


Return to Base

Who is online

Users browsing this forum: No registered users and 1 guest