Best way to prevent waking with leg cramps besides calcium magnesium supplements?

Off on and on I have had a problem with waking in the middle of the night with very painful leg cramps. It has been suggested to me that I take a calcium magnesium suppliment. I have tried that idea on two different ocations, and both times it really messed up my stomach very badly, so I cannot use that option.
Early this morning, i woke with a leg cramp again. Recently, I had begun taking this multivitamin suppliment in the form of a powdered drink mix, and I wonder if that could have caused the problem. I have also heard that leg cramps can be caused by not drinking enough, and i'm afraid i am guilty of that.
I would really appreciate any advice. Thank you

Thanks Lantana! Please tell me, how many bananas should i eat?? One a day? I love mushrooms. Does canned mushrooms do the trick though?
Please click on my name to send me a private message to answer this question. Thank you!!!!

Eat bananas - the potassium will help to prevent and alleviate the pain of the cramps. Mushrooms have more potassium, but you may not like them. Bananas are a safe bet for just about anyone though.

My mother use to wake up at night with bad leg cramps. It could be that your body is lacking potassium. She started eating a banana a day and her leg cramps stopped. You could also take a potassium supplement.

Leg cramps can be the result of too strenuous exercising,dehydration,electrolyte imbalances,low potassium,Taking certain medications like statins,and prednisone containing drugs,being over weight etc. Some MD's are using the new drug "Requip" to treat patients with severe night cramps. Others rely on "Quinine" for their patients. You can try a relaxing bath,some stretching exercises,and warm heat to the calf muscles.You may have to see your MD,to check for any electrolyte imbalances etc.Take care. SW RNP

I have tried drinking tonic water without the gin and the quinine in tonic water helps alleviate the cramps