"Train up a child in the way he should go." The emphasis in this passage is upon the way the child should go, not the way in which the parent would have the child go. The Jewish (Hebraic) understanding of this instruction is that it is incumbent upon parents to discern what gift, vision, and ambition a child has and then to work at providing instruction that will help the child to excel in fulfilling that goal. Children will not necessarily have the same preferences and skills as their parents. Each child is different, and each one's individuality must be respected and encouraged.
If God wanted children to be perfect replicas of their parents, he would have instituted cloning rather than childbirth. Parents who are wise, therefore, will not demand that their children live out parental fantasies but rather will encourage and equip them to pursue their own aspirations. --"Family Sanctuary," John Garr

