On 06-Mar-15 08:03, Vince (II): WA2RSX 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. Beginning to get a little feel for ooBase. 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?
A database is not the same as an spreadsheet. You store data in a database and use SQL to retrieve and sort the data.
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.
It's not that you can't insert a field anywhere in a row, it's only the user interface that is not user friendly, but
you can achieve it with SQL
Now, back to more tutorials.
I suggest you start learning about database basics here <http://www.htmlgoodies.com/primers/database/article.php/3478051>
Regards,Vince_B. On Monday, March 2, 2015 10:29 AM, Vince (II): WA2RSX <wa2...@yahoo.com> wrote:Using AOO 4.1.1 on Win8 machine. Followed tutorial (http://sheepdogguides.com/fdb/fdb1tableone.htm), and wonder why a field for ZipCode is not included. Now trying to revise/edit my NameAddrPhone table, which does have an ID (autofill) column, to include a ZipCode field. I would also like to include several fields to accommodate phone numbers for: Home#, Cell#, Work#1, Work#2, Work#3, etc. Or, is that something that would be placed within a second table? What am I missing that would allow me to modify my existing table's design, which has only one record within it at this point? Am I jumping the gun when trying to edit an existing table? TIA. Vince_B.
