relation problem
Posted: Wed Nov 07, 2012 1:30 pm
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
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