[Solved] Question about linked forms

Creating and using forms

[Solved] Question about linked forms

Postby IHaveNoName » Sat May 20, 2017 4:47 am

I have a simple database with two main forms: One is for customers at our business, and the other is for invidual jobs. They're linked, since each customer can have many jobs, and the Jobs Form has a dropdown menu where I can choose the customer name. That part works fine, but I have a question. If I fill out a customer form, I have to close the form before that customer's name appears on the dropdown menu in the Jobs form. Is that how it's supposed to work? I mean, I've tried saving after making a new record, clicking New Record, and simply skipping to the next one, but it only works if I actually close it.
Last edited by IHaveNoName on Sun May 21, 2017 3:23 am, edited 1 time in total.
Open Office 4.1.3 on Windows 7
IHaveNoName
 
Posts: 20
Joined: Sun Apr 30, 2017 1:37 am

Re: Question about linked forms

Postby charlie.it » Sat May 20, 2017 9:26 am

Ciao, did you try with a button with the property Action set to Refresh form ?
charlie AOO Italian Forum Admin https://forum.openoffice.org/it/forum/index.php
Apache Open Office 4.1.3 - Libre Office 4.3.7 - NeoOffice 3.4.1
on Mac OSX 10.7.5 Lion / macOS 10.12.1 Sierra (dual boot)
User avatar
charlie.it
Volunteer
 
Posts: 267
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: Question about linked forms

Postby Villeroy » Sat May 20, 2017 10:50 am

The navigation toolbar has 2 refresh buttons. One for the whole form and another for the currently focussed list box or combo box.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24584
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Question about linked forms

Postby UnklDonald418 » Sat May 20, 2017 8:25 pm

If I fill out a customer form, I have to close the form before that customer's name appears on the dropdown menu in the Jobs form. Is that how it's supposed to work?

If the Job Info form is already open when you add a new entry in your Customer Info table, the Job Info form is not aware of the changes to the Customer Info table. As Villeroy pointed out the Refresh Control button on the Navigation toolbar tells the form to reload the data from the Customer Info table.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the subject line
Apache OpenOffice 4.1.4 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 574
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Question about linked forms

Postby UnklDonald418 » Sat May 20, 2017 8:40 pm

I forgot to mention that the Refresh Control button will only work if the list box control has the focus.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the subject line
Apache OpenOffice 4.1.4 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 574
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Question about linked forms

Postby IHaveNoName » Sun May 21, 2017 3:23 am

Aha! I got it now. Thanks a bunch - I just hope I can remember to do that when I'm working on it. :P
Open Office 4.1.3 on Windows 7
IHaveNoName
 
Posts: 20
Joined: Sun Apr 30, 2017 1:37 am

Re: [Solved] Question about linked forms

Postby UnklDonald418 » Sun May 21, 2017 6:00 pm

I just hope I can remember to do that when I'm working on it.

You can easily add a Label control to your form that would contain a reminder.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the subject line
Apache OpenOffice 4.1.4 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 574
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: [Solved] Question about linked forms

Postby robleyd » Mon May 22, 2017 3:48 am

Or the low tech approach - a post-it note on the monitor :D
Cheers
David
Apache OpenOffice 4.1.4 - Windows 7
Apache OpenOffice 4.2.0 - Slackware 14.2 - 64 bit
User avatar
robleyd
Volunteer
 
Posts: 1012
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests