I think it's a combination of luck of the draw and your own attitude/approach. I have two daughters-in-law and feel extremely lucky. I get on very well with one of them and would say we are close. The other one has an entirely different personality to me and our relationship is OK.
As others have said, there's need to force a close relationship. I remind myself that my sons chose these women and love them - that's the most important thing.
Makerfield: Reform candidate sexist?
