Thanks for the idea, but I can't change "=" to "==" in the designer. I've made the view programtically as Cetin Basoz suggested and now it works fine.

Thanks!

>Hi!
>
>Yes. Try to change "=" to "==" for linking conditions, and assure all *_code field has the same length. Or just use SET EXACT ON command before query running.
>
>>They are characters. Does it make any difference?
>>
>>>Hi!
>>>
>>>What is a type of the fields "*_code" in lookup table and main tables used for joining? Are they character?
>>>
>>>>Hi!
>>>>
>>>>I've created a view with view designer. It has one "Invioice" table and 3 related lookup tables ("customer", "type", "country") all related to "Invioice". I join these tables and select all fields from "Invoice" and "...name" fields from lookup tables ("customer", "type", "country"). In the result cursor the last lookup table's "...name" filed doesn't seem to show the correct names (all the rows shows the same data while the codes in "Invioice" table are different). What can be wrong? The first 2 related tables works fine. I've tried to change the order of the lookup tables but the problem is allways with last table.
>>>>
>>>>SELECT Invoice.*, Customer.cust_name, Type.type_name, Country.count_name;
>>>> FROM data1!Customer INNER JOIN data1!Invoice;
>>>> INNER JOIN data1!Type;
>>>> INNER JOIN data1!Country ;
>>>> ON Country.count_code = Invoice.count_code ;
>>>> ON Type.type_code = Invoice.type_code ;
>>>> ON Customer.cust_code = Invoice.cust_code
>>>>
>>>>Thanks for any help.