[libreoffice-users] Re: Base - form table grid new record on top

Am 07.09.2011 18:00, ncreamer wrote:
> This is very helpful. My setup is very similar to the example
> animals/persons/things setup - almost exact.  I tried to setup a form where
> I'm entering new people, while at the same time adding animal and things
> that may not have previously existed. In other words, I don't have a
> pre-populated list of animals and things. Ultimately I will have less than
> 100 things, but I may have many more animals.

Well, I managed to handle 5 or 6 relations with many thousands of 
persons and hundreds of related items/sessions/insurances in such forms.
Base forms are far from perfect but fairly usable without macros and 
with a little bit of user training ("fishing" the right person out of 
thousands of concatenated list box entries).

> My form, while not perfect, allows me to enter animals and things at the
> same time I'm creating new people.  I can't tell from the example if there
> is one form designed to enter everything or if you're meant to enter them in
> separate places.  I have a text field for entering animals and then goto the
> form/subform where I have people/animals (a second instance) setup with
> "Animal"."Name" as a list box adding related records from "animal" to
> "persons"  Hope I described that correctly.
Right, we can open a form, add a new record to the main form (navigating 
behind the last record) and then we assign related items from other 
tables picking them from a list box. BUT we can not fill the list box 
with new items on the fly. Such a new item may have many required 
attributes, so simply typing a new item name could not append a valid 
new record.
I use to solve this problem with 2 forms in 2 windows or with an 
additional independent form attached to the same form document:
- Right-click the top-level "Forms" container in the form navigator tool 
and add a new main form (not a subform of another main form).
- Bind it to the table where you want to add new list box items and set 
property "insert new data only" so this form navigates automatically to 
the very last row for new entries. Add the required controls and a save 
button as default button, so it responds to the Enter key.

When your list box is missing some item, you can use the new form to add 
the new item with all its required attributes. Then focus the list box 
again and hit the second refresh button on the navigation toolbar. This 
button refreshes the selected list box without jumping to another record 
nor any selected value.


> I believe you're right about form placement and I'll play with that a bit
> and post back results.  Thanks for your time. Example .odb files are great
> because I can really see what's going on and relate it to my own experience.

Found another form with movies related to multiple genres and an 
additonal form to add a missing genre to the list box:
> http://user.services.openoffice.org/en/forum/download/file.php?id=2879


> --
> View this message in context: 
> http://nabble.documentfoundation.org/Base-form-table-grid-new-record-on-top-tp3314448p3317144.html
> Sent from the Users mailing list archive at Nabble.com.



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted