I have a db in MySQL 4.0.18 and i'm using a Java connection with mysql connector
3.0.11 stable. I'm on Win XP SP1.
My db (STATORD) is simple:

Table: CATPROD
Fields: ID_CATP (primary key), DESCAT

Table: SERIEPROD
Fields: ID_SERIE (primary key), CATP, DESCSERIE

ID_CATP and CATP are the common key fields.

In OOo 1.1.3 i create a simple main Form, linked to the CATPROD table.
(Note: i'm sorry if some terms differ from those present in OOo english version:
i'm using the italian version)

I create a table control in the form with fields ID_CATP and DESCAT
I also create a listbox (for verify the same behaviour) defined (in the Data
tab) as follow:
field: ID_CATP   field linked: 1   list content type: sql
content: SELECT `descat`, `id_catp` FROM `statordini`.`catprod`

I create a SUBFORM, defined as follow:
Content type: SQL statement
content: Select * From serieprod Where catp = :categ
parse SQL statement: Yes
link from (the field in the main form): ID_CATP
lind to (the variable name): categ

I close the "Draft" mode and save the document. Now if i select a value from the
1st table or from the listbox the correct list is filtered and shown in the 2nd
table.

Now i come back to the "Draf" mode and select the SUBFORM

*** PROBLEMS STARTS FROM HERE ***

Since i need to select a value from the subform in a listbox and not in a table
control, i click the LISTBOX button and draw one.

I immediately get an error message:
"Could not connect to the data source.
No value specified for parameter 1"

I click "OK" and the AutoPilot for the listbox starts, proposing to link to a
datasource and a table. I clic "Cancel" in the dialog, because it should change
my SUBFORM datasource.

I try to set manually my new listbox, so i activate the Control Properties box
an d click to the Data tab. I set it as follow:
Data field:  DESCSERIE
Linked field: 1
List content type: Table
List Content: STATORD.SERIEPROD

In the General tab i also set the "Can open" box (i don't know the eng form for
this) to "Yes", so i can open the listbox.

I close the "Draft" mode again and try to navigate the form.
The 2nd listbox, of the subform does not work, it is "disconnected" to the main
form and lists ALL the values of the ID_SERIE field.

It appears there is no way to make the listbox to show the correct list, no
matter which fields you link it to or setting the content type to an SQL statement.

I see a big problem to replace something like M$ Access in this area...