Tower Defense Simulator Bullet Positioning

Help and Feedback Scripting Support
1

The bullet positioning not working.

Code:

local function ShowBulletTrail(tower, enemy)
	print(tower, enemy)
	local distance = (enemy.HumanoidRootPart.Position - tower.HumanoidRootPart.Position).Magnitude
	local bullet = Instance.new("Part", workspace)
	print(bullet.Parent)
	bullet.Anchored = true
	bullet.Transparency = 0.5
	bullet.Material = Enum.Material.Neon
	bullet.Color = Color3.fromRGB(255, 82, 29)
	bullet.CanCollide = false
	
	bullet.Size = Vector3.new(0.05,0.05, distance)
	bullet.CFrame = CFrame.new(tower.HumanoidRootPart.Position, (enemy.HumanoidRootPart.CFrame * CFrame.new(0, 0, distance/2)).lookVector)

	task.wait(0.05)
	bullet:Destroy()
end

Concept:
image

Reply me if you need more detail. Thank you