Brian, thank you: You hit on very good points, and I do appreciate them. So, to edit data within a Table, use the Edit menu tab near top of screen; to edit the structure of Table, use the context- menu while Table name is highlighted.
I am no expert at using spreadsheets either, but am finding my knowledge of spreadsheets, such as it may be, to be confusing my attempts to learn ooBase at this point! As the saying goes: Difficult to change or break old habits. ... Am presently working on learning the basic use of Forms. Difficulty is in becoming aware of the required workflow steps for using Tables and Forms in a database manager system. Challenge at this point is to get the Form to be synced with the Table, and vice versa. Have not yet grasped the concept of a "Relational Database Manager System". For now, I am trying to learn the basics, and, ultimately, have a useful end- product whenever I feel successful! Regards, Vince_B. Sent from my iPad > On Mar 6, 2015, at 03:19, Brian Barker <b.m.bar...@btinternet.com> wrote: > > At 21:03 05/03/2015 +0000, Vince Bonly wrote: >> OKay! Have learned that table editing must be initiated via a right-click >> drop-down menu on the highlighted name of table, rather than attempting to >> use the menu-bar's "Edit" tab. I knew it was a simple solution. > > That's not true: you can always use the menus. There are two things you might > mean by "editing": modifying the table design (which is what you originally > asked about - adding another field to an existing table) and editing the data > the table contains. > > o To modify the table design, you can use Edit in the context (right-click) > menu, but you can indeed get to the same Table Design view via Edit | Edit... > . > > o To modify a table's data, you need Table Data View instead. You can > double-click the icon, use Open in the context menu, or go to Edit | Open > Database Object... . > >> My next task is to be able to insert a row between two already existing >> rows; is this possible, rather than the added row being located at the >> bottom of the table, i,e., last field? I have managed to add several new >> fields; however, it seems that these must always be appended following the >> presently last field within the table. Hmm. > > The order of records in the table display in a database shouldn't matter. The > way you use a database is not by examining tables but through queries, forms, > or reports. The displays you actually see should not depend on the order of > records in any table, I think. > > If it helps, you can reorder records in a table using the sort facility. If > sorting on existing fields cannot produce the order you require, you could > add an additional field to indicate the order and then sort on that. But, as > I say, I don't think you should particularly want to do this. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
