Apache OpenOffice Community Forum

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.

Ciao, did you try with a button with the property Action set to Refresh form ?

The navigation toolbar has 2 refresh buttons. One for the whole form and another for the currently focussed list box or combo box.

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.

I forgot to mention that the Refresh Control button will only work if the list box control has the focus.

Aha! I got it now. Thanks a bunch - I just hope I can remember to do that when I'm working on it.

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.

Or the low tech approach - a post-it note on the monitor