Am 01.11.2014 um 12:19 schrieb Marion & Noel Lodge: > Hi Andreas, > > Thanks for your detailed reply. After I had sent my message, I realised > that I had neglected to mention that I am using the H2 database. > > I went back into Tools | Relationships and decided to remove the the > relationship lines so that I could manually make the changes I wanted. I > discovered that for two of the relationships it took three attempts to > delete the lines. That made me wonder if I had somehow managed to link my > tables three times! So I reinstated the relationships using the "New > Relation" button rather than dragging the lines. Then, to my surprise, I > discovered that "Update cascade" worked!! >
Learning a little bit of SQL you can save a lot of time and effort. The things you need to know learn about creation and modification of tables, fields and indexes are very simple. There are text editors which help you to compose statements from prepared snippets. Well, even a Writer template can be spiced up with some auto-text in SQL language. Even the most simple plain text editor lets me define a table with primary key, default values and foreign key faster than the Base GUI. Back to Base, you have to call menu:View>Refresh Tables. And yes, sometimes it is a good idea to restart the office suite. Using an external database such as H2 keeps your data safe and warm. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted