It is inappropriate to have relationships with subordinates.
It's inappropriate to use coercion.
This is questionable in the context of one of the adults holding a position of power. Also, even when assuming the adults are peers, there's another saying 'Don't shit where you eat' which is rooted in a lot of stories of workplace relationships going wrong in very creative ways.
2. Other employees might feel that the employee having sex with the manager is getting better treatment at work.