Dr. Crusher: Woman he had his eye on ever since his best friend married her. In the series finale they are shown to have been husband and wife in the future. I thought the relationship had potential in theory, tepid in execution.
Nella Daren: The new head of stellar sciences charms the captain and they share a love of music. She establishes an interesting relationship with Dr. Crusher, who seems torn between happiness for the captain and a little disappointment/jealousy.
She's a favorite of mine and would be my number two pick, but in a legitimate (not soap opera) love triangle with Picard and Dr. Crusher, though not something I think TV back then or even today.
Kamala: An empathic metamorph groomed by the Kriosians to finalize a peace treaty, she imprinted herself on Picard and his own sense of duty shaped her determination to go on with her mission.
In some ways she's my favorite, but can't tell if her interest in Picard was genuine are just of limited opportunity.
Vash: An capitalistic archaeologist he met on a vacation on Risa and later spirited away by Q.
Minuet: A holodeck character that heavily charmed both Riker and Picard simultaneously while the Bynars are working on the ship.
Marta Batanides: One of Picard's best friends at the academy and someone he always regretted not taking a chance with, which he fixed to bad consequences in Tapestry when Q took him back in time. Probably still around.
A.F.: Initials of a girlfriend he carved in one of Boothby's trees as mentioned by Wesley in "The Game". Project away.
Eline: His wife on Kataan, when he was "Kamin" from the episode "Inner Light". Nice.
Jenice Manheim: Married to time scientist Paul Manheim, a girlfriend Picard was to meet in a Paris cafe des artistes the day before he shipped out but chickened out.
Phillipa Louvois: Antagonistic relations. Implied relationship before this JAG officer prosecuted him for the Stargazer and later presided over Data's hearing.
Tasha Yar: No relationship, but she awkwardly flirted with him in Hide and Q after she cried being in the penalty box and he consoled her. She replied :"Thank you, Captain... oooo, if you weren't a captain..." while making eyes. Just awkward and even Q commented. Might have been a desire on her part.
Anij: Star Trek Insurrection. Haven't seen this movie, know nothing about it.
Q: This guy has an affixation on Picard, even mention and comparing later Star Trek Captains he met to them. Comments to Picard in the Robin Hood episode that he should have appeared to him as a woman.
Riker: Yeah, guy driven to become a star ship captain now turns down 3 promotions to captain, what is up?
Of the women on this list, flirted with Minuet, kissed by Kamala, hit on Vash, and was essentially propositioned by Q (to become Q), seems Riker wants to second to Picard in other areas too
Sorry if I forgot someone.
Nella Daren: The new head of stellar sciences charms the captain and they share a love of music. She establishes an interesting relationship with Dr. Crusher, who seems torn between happiness for the captain and a little disappointment/jealousy.
She's a favorite of mine and would be my number two pick, but in a legitimate (not soap opera) love triangle with Picard and Dr. Crusher, though not something I think TV back then or even today.
Kamala: An empathic metamorph groomed by the Kriosians to finalize a peace treaty, she imprinted herself on Picard and his own sense of duty shaped her determination to go on with her mission.
In some ways she's my favorite, but can't tell if her interest in Picard was genuine are just of limited opportunity.
Vash: An capitalistic archaeologist he met on a vacation on Risa and later spirited away by Q.
Minuet: A holodeck character that heavily charmed both Riker and Picard simultaneously while the Bynars are working on the ship.
Marta Batanides: One of Picard's best friends at the academy and someone he always regretted not taking a chance with, which he fixed to bad consequences in Tapestry when Q took him back in time. Probably still around.
A.F.: Initials of a girlfriend he carved in one of Boothby's trees as mentioned by Wesley in "The Game". Project away.
Eline: His wife on Kataan, when he was "Kamin" from the episode "Inner Light". Nice.
Jenice Manheim: Married to time scientist Paul Manheim, a girlfriend Picard was to meet in a Paris cafe des artistes the day before he shipped out but chickened out.
Phillipa Louvois: Antagonistic relations. Implied relationship before this JAG officer prosecuted him for the Stargazer and later presided over Data's hearing.
Tasha Yar: No relationship, but she awkwardly flirted with him in Hide and Q after she cried being in the penalty box and he consoled her. She replied :"Thank you, Captain... oooo, if you weren't a captain..." while making eyes. Just awkward and even Q commented. Might have been a desire on her part.

Anij: Star Trek Insurrection. Haven't seen this movie, know nothing about it.
Q: This guy has an affixation on Picard, even mention and comparing later Star Trek Captains he met to them. Comments to Picard in the Robin Hood episode that he should have appeared to him as a woman.
Riker: Yeah, guy driven to become a star ship captain now turns down 3 promotions to captain, what is up?


Sorry if I forgot someone.