Page 1 of 1

Using multiple tables in one form?

Posted: Tue Jul 27, 2010 11:16 pm
by genolark
Here's what I have: OpenOffice 3.2.1 running on Windows Server 2003 SBS R2. I have setup a wamp server that we use for our other programs that require mysql. But I also have the OOoBase MySQL ODBC driver installed and setup. We have a database created in MySQL that has a number of. That number in the future will increase as we add more data requirements.

Ok so here's what I need. I need to be able to take data from multiple tables in one database and be able to display that data in one form and also be able to create, edit, and delete records. I have tried setting up a query for this but I can only get it to display the data in read only, it will not let me modify the records. Is there any way someone can go over this with me from square one and work my way through this so I can get it working the way we need it to work for us. I would really be grateful for any help anyone can provide.

Re: Using multiple tables in one form?

Posted: Wed Jul 28, 2010 7:49 am
by r4zoli
Queries in OOo not editable as in other programs, it is read only.
Only tables can be used for data input with forms.

Re: Using multiple tables in one form?

Posted: Wed Jul 28, 2010 6:37 pm
by genolark
Ok I figured that so what am I supposed to do then to be able to edit data from multiple tables with one form?????

Re: Using multiple tables in one form?

Posted: Wed Jul 28, 2010 7:49 pm
by r4zoli
You can add so much subforms as many tables you have if it fits into one form.

[Tutorial] Creating a form in Design view

[Tutorial] Forms in OpenOffice.org Base