Wikipedia
Qpid
"Qpid" is the 94th episode of the syndicated American science fiction television series Star Trek: The Next Generation, the 20th episode of the fourth season.
The captain and Vash are reunited when the Enterprise hosts an archaeology symposium, but their disparate personalities soon have them sparring instead of spooning. Enter Q, who offers to do Captain Picard a favor by getting him and his ladylove back together again. When Picard rejects the notion, Q transforms the captain into Robin Hood and sends him, Vash, and several members of Picard's senior staff to Sherwood Forest for a less than idyllic romp.