ZeCow is absolutely right. SATA is one cable per device. There are no master/slave relationships with those devices.
You'll need to pick up another SATA cable in order to hook up both devices. Go to a computer parts store (i.e. Microcenter) or order off of the internet. The cables are cheap and come in various lengths. Monoprice.com carries the cables and they have good prices.
Okay, I think I have it wrong, then. I was looking at the power cable. Then i guess I have plenty of SATA cables.
But so that means the power cable is capable of powering two SATA drives. Should I then use that one cable for both HDD and DVD-RW drive, or is it better for each to have its own dedicated power cable?
Intel Core 2 Quad 2.4
Asus Rampage Formula motherboard
1TB Seagate HDD
8GB Corasir dual-channel DDR2 800Mhz (4 sticks of 2GB)
I've been doing a lot of research, and I thought I had accumulated enough knowledge that assembling my rig would be a breeze, but I guess I don't know much if I couldn't tell the difference between a power cable and a SATA cable.