The only one I can be sure of is vash. The woman in Lessons" all they implied was a kiss.
sharegood question, I know he hooked up with Vash a few times, but really cant remember any other at the moment, he did have several women hitting on him, but I dont think sex was ever implied.
sharePicard got very friendly with Anij in Star Trek Insurrection so he might have got some then as well.
shareI had a friend who, halfway through the show's original run, insisted that he was having an ongoing affair with Crusher.
Which is not compatible with that "... and then I no longer had those feelings" speech that came in the later seasons, maybe they had an on-off relationship that started during the series and finally ended when their later marriage broke up. And it's definitely not incompatible with having breakfast together every day.
He was too occupied for that, and needed to keep up immaculate appearances.
But no doubt, during downtime Picard was sneaking off to the holo deck for a little play time.
Most probably alone, lone wolf style. Or if he did have a partner in his seedy $ex dungeons, it would be Jordy as his wing man, and he ordered him to remove his glasses so he couldn't see exactly what went down.
It won't be Ryker, as he was too busy banging real women.