How can I erase part of a mesh using another mesh?
This can be accomplished with a boolean modifier.

Add it on the large mesh and set the type to difference, then set the smaller mesh as it's target.



once you apply the modifier, you will have a hole in the large mesh, you may delete the small mesh