Problem using form-based-filter: ambiguous column name

[julian]

I have a database schema with 2 tables with a same column name, Table1.dataNamefield and Table2.dataNamefield. Also I’ve a form with a text box whose datafield is one of the two columns mentioned previously. If I try to use a form –based filter putting a value in the text box appears the next error:

Data content could not be uploaded
[Microsoft] [ODBC SQL Server Driver] [SQL Server] ambiguous column name ‘X’

then I check the additional information of the error and I see query and I can see:
AND ( ( "dataNamefield" = 'value' ) ) There isn’t the name of the table ahead.

But when I created the query I specified the table

I also tried to put an alias in the query but also doesn’t work.
Is it a possible bug?

[Villeroy]

Create an alias for at least one of the ambiguous names.

Code: Select all

SELECT "Table1"."dataNamefield" AS "Alias 1","Table2"."dataNamefield" AS "Alias 2" FROM ...

[julian]

I've Create an alias for both of the ambiguous names, but still doesn't work