Hi all,

I have the following problem:

Tables in Firebird DB:
Address (Name varchar(50), CountryID integer, StatusID integer)
Country (ID integer, CountryName varchar(50))
Status (ID integer, StatusName varchar(50))

A address may (but must not) have a CountryID and a StatusID.
So the table Address could look like this:

Name | CountryID | StatusID
---------------------------
a1 | 1| 5
a2 | NULL| NULL
a3 | NULL| 1
a4 | 2| 1
a5 | NULL| NULL


All tables are filled with data.

All tables are linked to an MS Access DB via ODBC.

When I creat a query in MS Access which combines the three
tables I get unexpected results, because I get data from
the tables Country and Status linked to rows of Address
where CoutryID or StatusID is NULL:

Name | CountryName | StatusName
-------------------------------
a1 | c1| s5
a2 | NULL| s5
a3 | NULL| s5
a4 | c2| s1
a5 | NULL| s1

When I import the data into my Access DB, the the query
works fine.

I have tried this with the Gemini ODBC Driver 2.1 and
the Easy Soft Interbase 6 ODBC driver. The result is
the same....

Firebird: 1.5 RC6
Access: 2002 SP2

What am I doing wrong?

Any ideas or hints?

Regards

Jürgen