Hi experts,

We are trying to work with mutiple databases. So we added both, now we need to define the connection between. Linkage is one field (delivery note).

Database one

Delivery note some fields

Database two

Delivery note some more fields

So we say: database1.dnote EQ database2.dnote --> no printout, strange, as in both files we have the same dnote number (as the only entry, 2000).

Next test, we added some more fake dnotes to database 2, all higher than the origin (e.g. 2000, 2001, 2002, 2003)

Now my connection is db2.dnote <> db1.dnote

=> result: I have 3 printouts (dnote 2001, 2002, 2003)

Strange

Next test, now my connection is db2.dnote >= db1.dnote

=> result, I have 4 printouts (dnote 2000, 2001, 2002, 2003).

So in this case, the EQ seems to work?

Any ideas?