David, don't worry, I am sure you are not alone. I think everyone "once" has locked their keys in the car. I did it - and boy, did I ever feel stupid.
I was meeting friends for dinner and had to tell them I had to go back to the car and wait for the Auto Club to come to unlock my car. They just looked at me and had that look of "boy, is she stupid or what?"
