I'm a SAHM. My DD is 17mo and I literally cannot leave with with anyone even for 5 minutes, except maybe with her dad. If I do, she will cry non stop.
We have a housekeeper in the U.K., who was originally hired as a nanny but due to the fact I can't leave my daughter she became a housekeeper. Still, my DD sees this lady every day, plays with her, will "help" her by putting the washing machine on as long as I'm nearby but the second I leave (even to the toilet) she will scream MAMMMMAAAAAAA MAMMMMMMAAAAAA and not play at all.
My own mum visits us quite often, stays for about 1 week out of every month. My daughter happily plays with her but the minute I decide to leave them in the same room whilst I go upstairs to put some shoes on it's MAMMMMMAAAAAA again.
Sometimes I'll go on holiday with my mum and DD, like now. We're unable to go to the restaurant even though we've taken the nanny / housekeeper with us. If, for example, she's going to look at some fish tanks in the restaurant I have to come with her. She will approach the table, grab my hand and drag me until I join. If I don't join she screams and falls to the floor. Queue disapproving looks from everyone in the restaurant and even my own mother.
I could leave her with my husband but that means no date nights for us and also he works so isn't always available if I have, for example, a doctors appointment during the week. On holiday often he can't come as he works but when he can we would just end up having dinner separately even if we take the nanny.