Sure thing on the quick responce. This is one way I repay for the "free" software.
I don't see anything wrong with your table relationships
I would ensure the data in the tables fits the description of the data type *FOR THE HSQL* database. This is probably your problem--you are trying to get data into a field that has been constrained to be another type of data. This might be helpful:http://java.sun.com/docs/books/tutorial ... types.htmlhttp://www.hsqldb.org/doc/guide/ch09.ht ... es-section
Also read the "SET REFERENTIAL INTEGRITY" part of this document as well
You can do this via Tools | SQL | Type in "SET REFERENTIAL_INTEGRITY FALSE;" | Execute
A side note to be taken not as criticism but hopefully as a helpful note: In your Orders, Issues, and Mailings tables you might want to have a unique ID of "ID" and set it to be your primary key just like you already have in your Address0 table. This will help in the future if you ever want to do more than very simply stuff. Also, break your Customer (or any other) field out into its parts, for example Customer_FirstName, Customer_LastName, etc. This will also payoff in the long run for the same reason. Then again, I could be reading things wrong and this structure has been working for you for a long time already.
If someone posts a fix for your question, then please post a quick thank you and then go to your first post, use the edit button to add [Solved] as the first word of the title so other people can rely on the fix as well.
LibreOffice 3.3.3 on Fedora