Really confused please help

I’m really confused right now and could use some inputs. My fiancé told me that he fingered another woman today. Obviously I feel really hurt. But what’s confusing me is that I still want to be with him. I can still see me married to him. That I do want to work this out and mend our relationship. Basically I love him so much that I’m willing to look past what he did. He says that he won’t do it again and that he’ll do what ever it takes to work this out. What do you guys think I should do.