Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

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,

Unsubscribe instructions: E-mail to
List archive:
*** All posts to this list are publicly archived for eternity ***


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.