I can't help but I have also been looking for ways to create bullets smashing through glass (I'm trying to make bullets smash through a glass elevator door) but I cant find a thing. The best way I've found for doing it on metal is just to make a hole in it and apply a bullet hole picture in front of it, which looks okay from a distance, but close ups are bad. To make bullet holes in plaster walls, create a bullet shape and apply a plasters material to it. Then create a stone about ywice the height and width of the bullt, but not as deep. Again apply a plastery texture to it. Place the stone on the flat side of the bullet, (the back of the bullet, or opposite to the pointy bit) DO NOT GROUP THEM. Make the stone and bullet Negative. Create a wall, and add a texture to it. Make it positive then duplicate it. Make this new wall negative, but slightly smaller and group it with the positive wall. The wall is now hoolw, which is vital for the debris to have a plaster effect on the outside. Call this group WALL. Select the wall and make it positive. Now move the stone and bullet into the wall so that the point is (obviosly) facing into the wall, with the stone at the back of the bullet halfway through the wall. With bullet, stone, and wall selected, click the Group button. There should now be an okay(ish) looking hole in your wall. Select this group (the wall with a hole in it) and Duplicate it (CTRL-D) Move the new wall off to the side and ungroup it. There should now be a stone, bullet and wall, plus the original wall group off to the side. Select the stone and bullet (the new ones) by pressing CTRL and SHIFT then clicking them. A small menu will open with a list of the objects that you have clicked. Tick and untick this box untill you have the stone and bullet selected. MAKE SURE YOU HAVE NOT MOVED THEM AWAY FROM THE WALL. Press the Atributes button and make them "intersect". Now, keep them selected and also select the wall (the second wall, not the one you will already have added a bullet hole in) and group them. HOPEFULLY the front of this new group will have the material you selected for your wall on it, but further back there will be a plaster texture. Name this group DEBRIS 1. Move it so that it fills the hole created in the original wall. Now, when you "animate" you can slowly have the DEBRIS fly off the wall leaving behind a hole. Hopefully. Well, I just wrote this as I went along, so I don't know if it will help, and in a sense is my first tutorial. I hope this helps, or you find a way to achieve the bullet hole effect. If you do, PLEASE post it here, as I have tried to find one but haven't been able to.

Thanks. The reason I haven't fixed where the viewer glances at the waterfall is because it takes AGES to render, and the frames with waterfall in take the longest. The version I posted took 3 days worth of rendering-the first few frames took an hour each! (Yes, I do have a slow pooter)