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?
3) How do I deal with the limitation of the ListBox where I can't seem
to store more than just the displayed string?
4) On a more general note, if the answer to (2) is "no", then why not?
This sort of structure is going to turn up in any but the most
trivial of databases. Making developers reinvent a (fairly complex)
wheel for every non-trivial database seems somewhat sub-optimal.
Hugo.
Hi Hugo,
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. The issue has
been logged into the issue tracker, but it is not slated for any
particular release at this time ( or at least was not when last I checked )
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.
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.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
