[libreoffice-users] Bug - Base: Default field value not saving or table dropping another field.

Greetings,
I am working on a contact management database in Libre Office 3.3.1. In it, I
have an Addresses table and an AddrTypes table.

The Address Types table has two fields: AddrTypeID (Primary Key, Integer,
autovalue) and AddrType (VarChar, 25 characters - specifying the type of
address... Home, Work, Mailing, etc.).

The Addresses table has the following fields:
AddrID (Primary Key, Integer, autovalue)
Address (VarChar, 75 characters, entry required)
City (VarChar, 70 characters, entry required)
State (VarChar, 2 characters, default:CA, entry required)
Zip (Integer, 10, entry required, formatted to look like a zip)
AddrTypeID (Foreign Key, Int, entry required, links to same field in AddrTypes)
PersonID (Foreign Key, Int, entry required, links to same field in People table)

Whenever I try to put a default value in Addresses.AddrTypeID, Base won't save
the table... not with the toolbar button, not with menu command, not with
keyboard shortcut. If I close the table, I get the message that the table has
been changed and do I want to save it. I click "Save" and Base returns me to the
table design view, as if I had clicked "Cancel."

If I "Save as..." and give the table a new name, then rename it back to its
original name, Base drops the PersonID field AND the default value for
AddrTypeID. Open the table back up in design view, and PersonID is gone. If I
put it back (and AddrTypeID default value), the table won't save (behavior as in
previous paragraph). However, once I delete AddrTypeID's default value, table
saves, just fine.

I even tried re-creating the table, from scratch, entering everything exactly as
I wanted it, in order, then saving straight to the correct name. No dice.
PersonID was gone when I reopened the table, along with AddrTypeID's default
value. Oddly, the "CA" default value for State has no issues.

Ideas? Solutions? Any help would be appreciated. Thanks in advance!

Fair day and be well,
Chris


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***