when I replace main table with updated information link, child(pivot) table relation throwing error as

[Ambi Krishnamoorthy]

Strange issue--

 

We have One main data table from Database and also we derived pivot table from main table. when I replace main table with updated information link, child(pivot) table relation throwing error as the relation is no longer valid , mapping column and data type are same

No change in main data table structure/columns as well, only we included one more parameter,

We got the same issue in one server but we can able to overwrite and fix it, but in another server we are unable to fix it because Manage relation OK button disabled though we update/change the relational column

 

Appreciate your help

[Aditya Singh 3]

Check if the datatype of column on which the relation is created is altered.

[Ambi Krishnamoorthy]

There is no change in datatype or anything as I mentioned above Addy, also we got to know It's product bug in 5.5

[Tom Tang 2]

hi, there

 

are there any solution for this issue my OK button is disable too, I just replaced my data tables and removed one column, so I just want to remove this column from relations too, button can not click OK to save the change.

 

thanks!

[Tom Tang 2]

ohh  I should remove the red relations all together, meaning choose all tables and delete red relations together, then I can click ok