If you want to stay with a Rapidweaver product, then I’d first highly recommend checking out Joe’s Foundation theme. The theme is rock-solid, fast, and comes with all the stacks you’d need (the extra packs 1 & 2 are flat-out awesome, but you don’t need them to build a site). On top of that, Joe’s customer support is stellar.
I feel for you- having to work with (I assume) ASP.net I built many a form using FormLoom and then had to strip out the PHP, and then compile the code to make the form work with ASP. Doing it once per form wasn’t too bad…but when changes to the fields was required, it was a nightmare. Everything had to be saved to an Access db, plus the recipient needed an auto-reply. I was never so happy as the day my boss called me in to say that they were putting PHP on my IIS server.
If I had it to do over again, I would buy a cheap hosting plan with a third party and host just the forms on that server. I’d then build them using MachForm - a super easy form builder that is beautiful, generates gorgeous replies, and should fields be added or deleted, no touching of any db is required (beyond the initial set-up…and, if that’s not your thing, the developer of MachForms is happy to log into your account and set it up…for FREE). Since you can’t run PHP on your server, you could use the popup method for generating the forms…and just link to it using a button.
You can see one of my forms that uses a button-link here Oh, and notice how the patient must select a center to be seen in? Based on that field, the submission automatically goes to different people.