On Sun, 2005-06-19 at 13:24 +0200, Roman Hausner wrote: > Base is continuing to puzzle me. Maybe somebody can > help me with this or point out where I could find > information?
This doesn't suprize me. Base, as a part of OOo2.0, is only at the beta candidate stage and is not recommended for production use. Perhaps http://documentation.openoffice.org/manuals/ will have some docs from which you can work. > > I am desperately trying to get an application running > where the front-end maintainence of mysql tables should be > done in OpenOffice. The deadline is approaching and > it does not seen that this can get solved in OO, while > it seems to work without problems in MS Access :( > Hmm, are you certain that you have a good working driver for MySQL? Check http://dba.openoffice.org/ to see if there are recommended drivers. > The main issue is still a way to edit many-to-many > relationships. I want the user to be able to > have several subforms in a main form. The main > form shows the main table information and the sub > forms are supposed to show the items that relate > to that row in the main table through a many-to-many > relationship. > > Some of the difficulties that arose are these: > > *) there is no direct support for many-to-many relations. > I wanted to solve this by having the subform edit the > many-to-many table and using a listbox to show the information > from the third table. > This worked as long as I had only one subform, but > when I added another (by copy-paste and changing the form > information), neither of the two forms worked any more. > The original form did not show any data any longer and > was totally unresponsive to clicks. > > *) How do I add a subform to an existing form? I was unable > to find any function that does this. Adding a subform > in the form navigator did not show anything in the main form? > > *) in the listbox control, what is the difference between > SQL and SQL (native) > > *) in the listbox control, what is the "bound field" number > supposed to mean? > > *) What is the menu option tools->Relationships supposed to do > and why does clicking it tell me that my DB does not support relations?? > > Is there any documentation out there about how to get this done? > Do you think it is at all possible to get this done with OO? > I would really want to implement this in OO, but if it is not > possible I will have to deliver it for MS Access :/ I cannot offer any more than what I recommended above. Again I caution you to reconsider using any beta candidate in production. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
