On the registration page, edit the insert record behavior and remove the redirect.
then add an authenticate user behavior to the registration page, make sure the authenticate user behavior code comes after the insert record code.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.