On Sun, Jan 06, 2008 at 05:28:19PM -0500, Drew Jensen wrote: > Hugo Mills wrote: > ><snip> > > So, my questions: > > > >1) Do I have the right idea for the user interface? > > > >2) Is there some easier way of implementing this type of data entry > > structure than the one I've chosen? [snip] > I am sorry to say you are not really missing anything - what you are > running into is one of the limitations of datasources in OpenOffice.org.
> The problem is that you can not have a resultset that joins multiple > tables and have it be updateable. It just doesn't work. [snip] > So you you have to split the work between a couple of forms or a form > and a dialog box. On the form you use a read only record set that shows > you who is assigned to what work - but to change add or remove either > side of that relationship you need a separate display. From this I infer that using subforms with the data linking feature actually constructs such a resultset internally? I'm not explicitly doing so -- my form is apparently using multiple separate tables, each in its own subform, with the subforms linked. > Back on OOoforum.org I posted up a long example of working with > Many-to-Many relationships with an example database - problem is that > example was written against a pre-2.0 release of OpenOffice and a bunch > of the example code is concerned with dealing with workaround of other > bugs in the package that no longer exist. Anyway I try not to point > people to it as a general example and have been too lazy ( I suppose ) > to go back and re-write it properly. You can still fine it there however > is you do a search or just send me a direct email at atjensen -at- > openoffice.org and I'll send you a copy of the example db and Basic > library that goes with it, if you like. This sounds like it's going to be more effort for me to implement in OpenOffice (an API and environment that I'm almost wholly unfamiliar with) than it will be to write a custom webapp using Python CGI (which I am familiar with). Thank you for your answer, though. Hugo. -- === Hugo Mills: [EMAIL PROTECTED] carfax.org.uk | darksatanic.net | lug.org.uk === PGP key: 515C238D from wwwkeys.eu.pgp.net or http://www.carfax.org.uk --- Ceci est un travail pour l'Australien. ---
signature.asc
Description: Digital signature
