Thanks so much, Alan! That works so far. Chuck
-----Original Message----- From: Alan B [mailto:abo...@gmail.com] Sent: Monday, January 04, 2016 5:24 PM To: Chuck Popenoe; users@openoffice.apache.org Subject: Re: Editing Source Data--What's the Secret? Hello Chuck, Sorry for the delayed response... am traveling. On Thu, Dec 31, 2015 at 10:08 AM, Chuck Popenoe <cp...@verizon.net> wrote: > Hi Alan, > > Interesting, that might be the Secret. Just what is the "primary key", > (never heard of it), and how do you add it to your table?ry keys the tables > could be edited. > What is a primary key? A value made from one or more columns in the table that uniquely identifies each row in the table. Note that just having the column(s) present doesn't meet the requirement. It/they must also be identified as a primary key. To add it to the table... 1. Open the database 2. Select the table 3. Select "Edit" from the table's properties menu 4. Right-click the border to the left of the Field Names column and select "Insert Rows" 5. type a field name, eg pKey and select Integer for field type 6. In "Field Properties" select AutoValue = Yes 7. Right-click in the border to the left of the new field name and select "Primary Key" Save your changes. The table will now be editable with a new field, pKey, that is automatically updated each time a row is added. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
