There's a joke Border Collie owners like to tell:
There was this guy who went to visit his friend, who had a Border Collie. "Where's the dog, Joe?" he asked, looking around and not seeing him.
"Oh, he's gone to do the shopping," says Joe. "He'll be back in half an hour or so."
"Shopping," says his friend. "What do you mean? How does that work?"
"Well, I put the grocery list and some money in a shopping basket and he takes it round the shops. He knows which ones to go to and they put the stuff in the basket and the change back in the envelope. After he's done the rounds, he brings it all back here. Simple, really."
His friend isn't quite sure if Joe's pulling his leg, so he says nothing.
But sure enough, twenty minutes later, he sees the dog trotting up the pavement with the shopping basket in his mouth. He puts it down, stands up to unlatch the gate, brings the basket up the front path, puts it down again and stands up to ring the doorbell.
"That's incredible. That's gotta be the smartest dog I've ever seen."
"Ah, he's not so smart," says Joe. "That's the second time this week he's forgotten his key."
Now maybe my border collie Maggie wasn't quite up to doing the grocery shopping, but she was certainly a delight to train. She could be 100 meters away and if I clicked my tongue she would come racing back to me and sit at my feet with her "Yes, boss, what do you want me to do?" look.
But all dogs can be trained to do this.
You just have to now what you're doing.