Mailinglist Archive: opensuse (2217 mails)

[G T Smith <grahamsmith@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Carlos E. R. wrote:
> 
> 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?
> 

I understand the problem.

I have a form with a sub-form linked via an index... Whenever I select
an entry in primary form I see all relevant entries linked in the
sub-form... Can edit and update records in both form and sub-form...,

Table structure is roughly

Table A

Index, data

Table B

Index, Link to A index, data

Form to Sub form relationship based on linking field 1 to field 2...

Your structure implies a read only join...

Adding a new subform entry is clunky... and adding primary entries is
definitely very clunky indeed (when committing a new entry tend to keep
ending up on first record in table, so you have to go to the last entry
and continue from there).



> 
> All the above works perfectly, and much faster and with less complexity, 
> with Rekall.
> 

- --
==============================================================================
I have always wished that my computer would be as easy to use as my
telephone.
My wish has come true. I no longer know how to use my telephone.

Bjarne Stroustrup
==============================================================================
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org

iD8DBQFG7l3vasN0sSnLmgIRAi7rAKCU0Z47X/YIQTQBAkvfVpd9nQw+WgCfVcGp
w3mgcRYtdjW1w1IWFdkxDW4=
=zNWm
-----END PGP SIGNATURE-----
-- 
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx