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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
