relation problem

[re4gi]

Hello,

I have found some problems with relations. In Designer in DataSource I have 2 connections, each connection has its own table, lets name them first_table and second_table. In the second_table I have string column which is a foreign column to the first_table. So I created relation in the second_table binding the foreign key column from the second_table with the primkey of the first_table. In the designer I created DataSource using the second_table. If I am using the TextBox to show the foreign key, I can see the value but when I am using the primkey through the relation of the second table then nothing is shown. When I was debugging I could see that the first_table is containing record with the referenced value. I get into this problem more times, sometimes was the solution deleting and creating of the relation once again but sometimes I am not able to solve it. Could you give me an advice?

Thank you,

Regards,

Regi

[Alex K.]

Hello,

Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.