Jim Richard wrote:
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.....
Thanks,
Jim
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?
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
