Well to answer you let's use some examples:
Let's pretend you have a 1:1 ratio. With that ratio, the RAM ALWAYS runs at the SAME speed as the FSB (or in AMD's case, the HTT)
You have a stock 200 HTT. Your RAM is running at 200 MHz (DDR400). Everyone is happy.
When you increase HTT to say, 225, your RAM speed has to keep the 1:1 ratio. That is, it must still run at the SAME speed as the HTT. So it must INCREASE its clock to 225 mhz, along with the CPU's HTT.
Now let's use a 3:4 multiplier as another example.
When you have a stock 200 HTT with the 3:4, your RAM and HTT are running in a locked 3:4 ratio. That is, for every 4 MHz of the HTT, the RAM speed increases by 3 MHz. so at 200 HTT the RAM speed would be 150 MHz.
Now let's say you overclock a bit and raise your HTT to 265. The memory cannot stay at 150 MHz because that would not keep the 3:4 ratio. It must also increase its speed, in this case to nearly 199 MHz.
This is if you use FIXED dividers. When you set it to "Auto", I think your board chooses the most appropriate divider for the HTT speed and modulates RAM speeds automatically. I could be wrong here though.
For more info read this guide:
http://forums.extremeoverclocking.com/showthread.php?t=149717