A Modern Affair (1996)

Grace Rhodes is the perfect Manhattan corporate executive--bright, successful and attractive. Grace feels she has everything she needs, until she bumps into an ex-boyfriend bearing photos of his young kids. Feeling the irresistible urge to have a child, but not wanting to wait around for Mr. Right, Grace enlist the services of a sperm bank. Deeply curious about her donor, known only as "#247," Grace tracks down Peter Kessler, a handsome photographer who divides his time between his craft, his casual affair with a married woman, and his "other job:" depositing specimens as a sperm donor to earn a little extra cash. When Grace and Peter finally meet, they begin the journey down the rocky road to parenthood and possibly from there to love.