-----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@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org