I need to change a field data type but when i try it tells me that i need to delete a relationship in the relationships window. but when i open the relationships window it doesn't show any.

My only guess is what I've ran into before ... right-click on the relationships window and left-click 'Show All'. It sometimes doesn't show them all .. if nothing appears - beats me.

-dK

OK now i see it. I also see why the relationship is interfering. but I can't seem to delete the relationship. I click the offending relationship and the 'X' delete button. and the relationship goes away. i click save. but if i "show all" again it reappears. How do I get it to go away and stay gone so i can change this data type?

Ughr?!

I have no idea unless you have something running in the background that keeps you from deleting it.

Anyone else?

-dK

I figured it out. I was clicking the box not the line for the acutal relationship. got it deleted.