Base subform creation problem. Parameter Input box, then error

[multiplexed]

Newbie alert here. If this post is wrong or if I need to provide more info, please let me know.

I’m following some tutorials on how to learn LibreOffice Base. I’m using the following …

• LibreOffice v5.1 Base

• MySQL ODBC connector (latest)

• MariaDB v10.0.20

• Windows 10 Pro x64 (Running LibreOffice)

• Windows Server 2012 R2 Standard (hosting MaraDB)

I’m having problems creating a subform.

I’m using the create a form wizard. I have added both my tables and joined the primary key fields (employee-ID). When I open and run the form, I get a dialog box asking for “Parameter Input” (see screenshot). I don’t know what to input, so I click OK. Then I get an error …

The data content could not be loaded.
SQL Status: 42S22
Error code: 1054

[MySQL][ODBC 5.3(w) Driver][mysqld-5.5.5-10.0.20-MariaDB]Unknown column 'ID' in 'where clause'

After clearing the error, the main form is populated with data. However, the bottom subform, has no data.

My question is, How do I get this subform to work, or how do I get rid of the “parameter input” dialog?

Here are some screenshots.

Parameter Input - dialog box to get rid of.

Main Form Window (edit: img not available)

Links (edit: img not available)

Form Properties (edit: img not available)

(edit: activated screenshots where available)

[peterwt]

Is - allowed in field name? May be being interpreted as minus. The error message shows only “ID” as column name whereas your names are proceeded by other text including -.

[multiplexed]

Thank you very much! I was stumped on this one. I created a backup database, then renamed the Employee-ID columns to Employee_ID. I saved and re-created my subform. Everything is working great now. Thank you very much for your advice!!!