Multigenerational consequences

I was listening to a sermon about the sin of David and Bathsheba that got me thinking about multigenerational consequences.
David's sin did not only effect himself, and not even those immediately surrounding him. His sin affected his future generation and those that were not in any way involved. The prophet Nathan comes to David and lays before him the consequences of his sin.

Wherefore has thou despised the commandment of the Lord, to do evil in his sight? Thous hast killed Uriah the Hittite with the sword, and thou hast taken his wife to be your wife, and hast slain him with the sword of the children of Ammon. Now therefore the sword shall never depart from thine house, because thou hast despised me, and taken the wife of Uriah the Hittite to be thy wife. Thus said the Lord, behold I will raise up evil against thee out of thine own house, and will take thy wives and give them unto they neighbor and he shall lie with thy wives in the sight of his sin. Thou thou diddest it secretly, but I will do this thing before all Israel and before the sun.
Then David said unto Nathan, I have sinned against the Lord. And Nathan said unto David, the Lord also hath put away thy sin, thou shalt not die. Howbeit because by this dead thou hast caused the enemies of the Lord to blaspheme, the child that is born unto thee shall surely die.
1 Samuel 12:9-14

No sooner we find in the next chapter that David son has raped his daughter and another of his sons kills this son, then tries to take over David's kingdom, lies with David's wives before all of Israel and eventually loses his life.

Another excellent example of multigenerational consequences is Abraham. Abraham impatient for the Lord's promise decides the Lord needs a little help and take Sarah's maid and conceives a child through her. The child that comes out of this relation is Ishmael, the father of a large group of Muslims, whom we are still waring against several thousands of years later.

Yet another example and the most devastating of them all is that of Adam. Because of his sin, the entire race of man kind has fallen into sin.

I think often times we don't (I know I don't) consider or realize the consequences of our sin. There tends to be this mind set among Christian today that we can just ask the Lord to forgive us and he will. And yes this is true if we repent he will forgive us, but there will still be consequences to our sin.
Maybe we will never live to see the consiquences, but will be that selfish, as to have our children, and our children's children suffer from our mistakes.

A violation of any magnitude great or small can produce large consequences for generations and possibly centuries to come.