I didn't see another question/answer on this topic - please point it out if you know of one.
I'm trying to get these two characters to pass this canteen. Making one Child Of constraint, to make the guy on the right pick it up off the table (previous shot) was easy. Getting that constraint to let go, and transfer to the guy on the left, isn't working. When I set right guy's constraint to 0, the canteen floats away. Switching "set inverse" and "clear inverse" doesn't seem to work.
For now, my workaround is to cut the scene at that frame, save the file as the next shot in sequence, and pick up the animation where this one leaves off. That way I can eliminate the constraints on one and have the other immediately start.