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 11:58 +0100, G T Smith wrote:
> 
>>> 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...,
> 
> Hum!
> 
> I tried via forms, but I couldn't get it right.
> 

Used the wizard, and I do not remember it being easy or intuitive. It is
about year ago 1 set this up, and for the life of me I cannot remember
how I did it at the moment. Should have taken notes :-)


<snip>

>> Your structure implies a read only join...
> 
>
> Huh? Rekall does it read write just fine.
>

In a strict one to many or many to many relationship an editable table
view does present a problem. When changing something on the many end of
a relationship one can be doing at least one of three things, making a
change which applies the edited record (i.e. correcting the spelling of
an authors name),  introducing a new record (i.e. adding an author for
an existing book), or changing the record relationship (changing the
author of the book). A more usual approach would be to have a read only
table view with a select and edit option (it is also relatively easy to
program)...



> It shows like this:
> 
>     Title                Author
>  ------------------     ---------
>  Robots and Empire      Asimov ^
>  Rendezvous with Rama   Clarke ^
> 
> The "Author" column fields are drop down lists from which I can choose an 
> author from any author in the authors table.
> 

This is something definitely missing from the OpenOffice stuff, a drop
down list derived from a database table is useful to have as option .
With the above you can change author easily, but the other two edits do
present a couple of issues....

However a question remains.... how do you handle something like?...

Programming Perl, by Larry Wall, Tom Christiansen & Jon Orwant ...

:-)

In OpenOffice you can currently build (very) basic data entry forms, and
generate queries and reports for incorporation into OpenOffice documents
(not something I think you can do with ReKall). On the other hand I
would definitely not consider OpenOffice for your requirement.... The
two things have somewhat different focuses.

>> 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).
> 
> Mmmm...





> 
> 

- --
==============================================================================
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

iD8DBQFG749lasN0sSnLmgIRAqjkAJ9WE+z+RFlpeCwAyd3GhAA6E8MYPQCg01Q6
kta3JiZKmnAm/wq1OjuzDdk=
=EMP5
-----END PGP SIGNATURE-----
-- 
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx