How do I insert a new row of data between two existing rows?

[Cheapster]

Um, that's it I think.

[Sliderule]

You do not.

The ORDER of data, entered or deleted is unimportant and irrelevant.

You can, if you want, include a SORT / ORDER instructions for a Query, to bring back data in a desired sequence.

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[Cheapster]

The order of data entered or deleted is very important to me. I wonder if what you mean is that the application does not allow such manipulation – if so, I concede that I may well have chosen the wrong application for the job I want to do.

Intelligibility is also important to me. As a newcomer to both OpenOffice and this forum,

[Sliderule]

Maybe, you need to explain better what you really want to do and why . . . so someone can give a more meaningful non-Serbo-Croat response.

A database ( this forum ) is made up of tables. The order data is entered is irrelevant.

You can have the database, bring back your data, filtered by any specific criteria you want ( for example . . . with a "LastName" starting with the characters 'Che' and if you desire, sorted / ordered by whatever field or fields you desire ).

See the links below for some 'Base Tutorials / Documentation / Videos' :

1. Base Tutorials: http://www.tutorialsforopenoffice.org/category_index/base.html
   
   
2. Database Documentation: http://wiki.services.openoffice.org/wiki/Database
   
   
3. Short Videos ( about 3 minutes each ) demonstrating the use of OpenOffice Base:
   
   http://showmedo.com/videotutorials/series?name=AXggL6j0a

Sliderule

Thanks to add [Solved] in your first post Title ( edit button ) if your issue has been fixed / resolved.

[dacm]

And while the data-entry (record / row / tuple) order is always irrelevant in the storage Table, you can certainly add a column (field) to the storage Table which you can use to specify the desired sort order. A Query can then sort the Table in the desired order for presentation or Reporting. For instance a storage Table might contain the following dedicated sort column:
4
2
5
1
3

...so a resulting Query table could be sorted as follows (ascending or descending):
1
2
3
4
5
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Migrating 'Embedded databases'