-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Monday 2007-09-17 at 09:26 +0100, G T Smith wrote:
Because in OOo I can't use tables with relations in read/write mode, only read.
Nope, I can do data entry without too much of a problem from the database view. Clunks a bit however....
I can write to single tables, not those with relation active. I'll try to explain again... My Library "Libros" table (simplified) is shown like this: Title Author_nm - ------------------ --------- Robots and Empire 1 Rendezvous with Rama 2 I can create a new entry, but I have to look up manually the number of the corresponding author, and write up the number, not the name. Do you see what I mean? This is useless. I can create a table view, that combines two tables, like this: Books Authors ------- --------- Book_ID +---> Author_ID Title | Author Author_ID -+ Now, the view shows correctly: Title Author - ------------------ --------- Robots and Empire Asimov Rendezvous with Rama Clarke But it is Read Only. Again, useless. Do you understand the problem now? All the above works perfectly, and much faster and with less complexity, with Rekall. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Made with pgp4pine 1.76 iD8DBQFG7lWNtTMYHG2NR9URAipdAJ9et5xM6nflBQ/HBUjojZ0BapFegQCcD4jO H7TLaQruX4d7Ezhsg2gg7qA= =XZLd -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org