Without a Clue (1988)
This is a Sherlock Holmes story with a difference. Here Dr Watson is the ace detective and has been using an actor to play the part Holmes. Holmes is a drunken actor and gets on Watson’s nerves. When Watson tries to go it alone, he doesn’t have much success, so he is forced to let Holmes take all the credit once more.