On 6/19/05, G. Roderick Singleton <[EMAIL PROTECTED]> wrote: > 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] > >
MyODBC is an excellent choice of drivers for Base/MySQL. However, g-roddy is probably right to suggest Base not be used for production just yet. -- Douglas Hernandez (612) 229-9684 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
