A single relay that is able to do it the way the diagram shows is called a double pole double throw (DPDT)
http://www.amazon.com/Dayton-1EJH2-..._2?s=industrial&ie=UTF8&qid=1316889920&sr=1-2
If you want motor in the morning and manual at night....
+ to door switch
door switch to 87
30 to motor
other side or motor to -
(switch polarity if motor runs backward from what you want)
disregard 87a altogether attach nothing.
http://www.amazon.com/Dayton-1EJH2-..._2?s=industrial&ie=UTF8&qid=1316889920&sr=1-2
If you want motor in the morning and manual at night....
+ to door switch
door switch to 87
30 to motor
other side or motor to -
(switch polarity if motor runs backward from what you want)
disregard 87a altogether attach nothing.