Faith of a child

Last night during prayers before bed Trey prayed that he would be able to go to his same school next yr. (the plan is to send them both to public school) So once again like when he was praying for a baby for over 2 yrs i am having to remind him of something i don't want to- that God doesn't always answer our prayers just the way we want him to. He very sadly said "i know" It's hard for me to know exactly how to handle things like this, i don't want him to doubt God, but i know also that unless a miracle happened he will be changing schools and i want him to be prepared but not feel that God did not answer his prayer. He breaks my heart -the other day he said " i have lot's of time before 2nd grade, i will save all my money and pay for it" Oh how i wish that would work Trey:) I guess this is the part of parenting i don't so much enjoy, i don't want to see sadness, dissapointment ect. But that is a very real part of life and i guess our job is to teach them how to handle those dissappointments and such...