I do not understand. Let's say, a person in the main form has a collection of items in a subform. As you append/edit/delete items to the subform each of them inherits the person-ID of the selected parent form and there should be no need to refresh anything in the parent form since the subform edits another table.
The database I have in mind is attached to: http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=40444 Each person (red) can be associated with one animal(blue) and with many things(yellow). You can edit/insert/delete all subforms without touching or refreshing the parent form. Or do you have a main form as "selector" for the same editable items in the subform? In this case you may have switched the roles of main and subforms. You should have one editable main form and all related (but not the same) data in as many subforms as needed so each form in that hierarchy reflects one editable row set, related to but different from the other row sets. There is also a technique which allows us to pick an item from a main form's list box in order to get the editable item attributes in a subform. This is described in http://user.services.openoffice.org/en/forum/viewtopic.php?f=100&t=42845 You can edit the subform content and refresh the list box only in the parent form using the second refresh button on the toolbar. This will refresh the list box content without modifying its selected item nor the record position. -- View this message in context: http://nabble.documentfoundation.org/Base-form-table-grid-new-record-on-top-tp3314448p3314566.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] 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
