Comment inline
On Wednesday 12 October 2005 05:07 pm, Jim Richard wrote:
> 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.
There are two places where the length of the field must be listed:
in the table, and in the form. Both are necessary. If the table has the
correct length (150) but the form does not (5), 2.0 RC1 gives an error
message anytime you try to save the data from the form that is over the
length of 5. Edit your form to make sure it is the proper length.
Dan
>
> 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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
