I understand what you're trying to do (I have an SSD in the optical drive spot too, using an OptiBay) but it's not super easy.
You want to have the drives setup thusly:
-SSD
--Partition1 (OS X)
--Partition2 (Win7)
-HDD
--Partition1 (OS X home directory)
--Partition2 (Windows home directory)
This is not something that Boot Camp Assistant will just "do for you". What you'll need to do is setup install OS X on the SSD with just one partition, then run boot camp assistant to repartition the drive and install Windows. Once both operating systems are up and stable, then partition the HDD and setup each OS to store their home directories on the respective HDD partitions.
You could potentially do this with a singly-partitioned HDD, but I would not recommend this route. OS X likes HFS+ and Windows 7 likes NTFS.
If you have a ton of files, you're probably going to need a 3rd external hard drive to temporarily store your stuff while you format the HDD.
Search the forums or macosxhints.com for ways to move your OS X home directory to another spot, it's not that difficult, but you must be painstaking about preserving your data.
As for Windows, you're on your own, but someone has surely done it and search will be your friend. On Windows XP, TweakUI could take care of this, but I would find a better solution, personally.