The movie appears to be made in the late 1990's and set in England. The story revolves around a married couple who can't have children and the husband hires a younger man to impregnate his wife. The younger man falls in love with the wife,and the husband has him murdered. I can't remember the actors/actress.

The Proposition (1998) (http://www.imdb.com/title/tt0120108/)

What was the movie with a retired shink in it... was a great movie... he goes back to work in a group setting for a friend

It also has a twist at the end...