Burra, what a lovely story!
Destiny, I have grown pumpkins in containers once, trellised up a
fence. They were able to grow up the
trellis just fine, after I initially tied up the vines while they were small. After that, they could cling and grow through themselves. As far as yield, I grew two vines, and each vine grew one small-ish pumpkin.
The containers were just old buckets. I put down a layer of
wood and sticks at the bottom, then a layer of
chicken manure, then a layer of garden soil.
The biggest challenge was keeping the containers watered. I was watering them two or three times a day, and they were still not getting enough
water. I then tried a "ghetto" drip irrigation system, which was basically a wine bottle full of water, upturned into the pot so that the potting
compost went into the neck of the bottle, forming a little cap; this cap of soil acted as a sponge, letting the water from the bottle out slowly so that the plants could take up the water slowly, instead of most of the water just running through the pot. It wasn't until I did this that the vines finally produced female flowers and formed pumpkins.
In the photo, my son is standing in front of one of the pumpkin containers, and you can see the remains of the old vine over his head.