I remember watching a Hollywood comedy movie in 2001 on Star Movies channel in India. The movie was from the 1990's. I have forgotten the name of the movie, but here is the plot:
There is a detective and three ladies. The first lady is the detective's wife, who is cheating on him and is planning with her boyfriend to kill him. The second lady is the Detective's assistant who is kind of cute and has a crush on the detective. The third lady is rich, wild, and highly sexual. She becomes obsessed with the detective.
The story revolves around these characters.
Please help me to identify this movie.