You have SharePoint 2007?
Several ways this can be done depending on how elaborate your workflow is.
In its simplest you can create an email submit and email the form to the manager selected.
There is a more robust, packaged work flow included in the Database AcceleratorQdabra Database Accelerator Suite Version 2.1 - Developer
Or you can use the WorkFlow functionality in MOSS 2007.