A Mistake at Work

I recently got separated from my wife after twenty years of marriage. It's been tough, but I've managed to keep things together at work until last week. I started a new job as a retail worker, and there was this attractive woman who worked in the store too. She was always friendly, and we would chat about our days. One day, she mentioned that her husband had recently left her, and somehow, something shifted between us. We were both alone and vulnerable, and one night after closing, I found myself in a very compromising situation with her. It felt like it could have been so much more, but now I'm worried about the repercussions at work and if this was just some misguided attempt to fill an emotional void left by my separation. Am I being too hard on myself? Is what we did common for people going through tough times?