Can you teach a herring to walk and if you do, will it drown if it goes back to the water?

I think you're talking about 'Mr Bohm & The Herring' by Peter Cohen from 1988, which was originally a book.