Dear Pablo --

Thanks a lot for your indications. i checked them out and they would be great for someone with quite a bit of computing skill and knowledge but one of the things i´m hoping to see with this new version of OO is something simple enough that a straightforward left join can be established on two tables which have been created through the Oo interface, a query made up which brings up the info from both tables and which would also allow you to begin inputting information or which could serve as the base upon which you could create forms and reports. The instructions which i read still require, however little, some code writing (not to mention understanding of what is going on behind the scenes) and i´m afraid the managers in my office aren´t all that interested in sending my co-workers to classes in Postgresql or HSQL programming just to be able to set up a couple of related tables input the info and run some queries on them. Gee, i had no idea it would be this tough...

   Anyway, Have a nice evening!      :-)



Pablo Lachmann wrote:

Hi!

Am 17.09.2005 um 17:19 schrieb Fred Frazelle:

Val, have you added any data to the tables yet and if so, how have you done this? i have been trying to do this for several months now by creating the two tables and then creating a query upon which to base my input form and reports but when i go to try and input the first row, the query comes up blank -- there is no first row from the left join of the two tables. If i create a form based on the query, no data can be input into the fields.


I don't know if I understood you correctly, but do you have two tables and want to insert some data in both of them? If this is what you intend, check the following tutorial:

http://documentation.openoffice.org/HOW_TO/data_source/link_tablehtml/ link.html#9.Creating%20a%20Form%20for%20the%20Data%20Source|outline (one line)

First I tried to use a query for my form, but I could not edit any data. The way it is described in the tutorial works for me.

Gruesse, Pablo




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to