Thanks for the reply, I was using version 1.1.3 and it will not access multiple tables, however I did download the 2.0 RC 2 version and it does it very well, however, I do have a problem in that the form will only allow you to enter data up to the same length of the largest existing entry, in other words if the structure is 150 chars and the largest so far is 5 chars then the max is 5.... pretty sure the problem is with the form because I can press <F4> and get the data-source and enter the data there with no restrictions. I do not believe that the problem exist with myODBC drivers either... I do have the same data entry problem with version 1.1.3 too.
I am going to double check myODBC drivers and settings. On Wednesday 12 October 2005 05:03 pm, CPHennessy wrote: > On Mon October 10 2005 17:26, + Jim Richard wrote: > > [ MODERATED ] *********************** > > I am using MySQL and have designed a form (with OpenOffice) however I am > > unable to get the form to get data from two different tables/fields > > within the same database.... > > > > Is it not possible....? > > > > My structure is: > > > > /phonebook (personal data - name, address etc) > > Addresses---> > > \business (business data - business name, contact etc) > > > > I would like a single form that could display, update, add etc., data to > > both tables. > > > > I can do this with a database front-end such as Knoda - however it would > > be more convient to do it all within OpenOffice..... > > As you are not subscribed you may not have seen that: > > On Mon October 10 2005 23:31, Andrew Douglas Pitonyak wrote: > > I have not had a problem creating a form that can access multiple > > tables. Typically, you will create a subform that links to a parent form > > and then indicate which fields are used for the link. In fact, if you > > use the form wizard, it should talk you through this. Hmmm, I am > > assuming that you are using 2.0 RC 2 rather than 1.1.5. Version 1.1.5 > > probably does not have a form wizard to automate these things. What > > version are you using? > > Please reply to [email protected] only. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
