Attach actor to an actor's skeletal mesh component

I have two actor blueprints in my level, one is a bottle with a liquid in it, all of the items in that blueprint are static meshes. The other is an actor blueprint with a skeletal mesh component. The skeletal mesh in the component has a socket and an animation blueprint assigned to it in the blueprint which all seems to be working fine. My problem is that I need to get the bottle actor to attach to the socket and move with it.

My problem is that instead of attaching to the socket, it seems to attach the bottle to the root of the skeletal mesh, unless I set the attachment type to ‘keep relative offset’ if I do this it appears to move the bottle to the socket but the bottle doesn’t follow the movement of the socket when I activate the animation.

Does anyone have any ideas?