Base is continuing to puzzle me. Maybe somebody can help me with this or point out where I could find information?
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 :( 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 :/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
