Which PVC cement?

[MikeP]

My plumbing is a combination of rigid and flexable PVC. What cement is best to use? I have heard too much conflicting info on what to use. I have heard any PVC cement will do just fine but I have also heard I need a special type to use with flexable PVC and that stuff is also good for rigid. This is a decision that I think has to be right so I just want to make sure. I bought a cement called 'IPS weld-on PVC 704' but then noticed the can made mention of rigid PVC but not flexable. What type (a name would be great) of cement do I need and where can I buy it.

Thanks for any help.