-----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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
