You have got this mostly worked out, the recordset on your details page seems fine to me. I think the problem is your missing URL parameters in the links you are creating.
You will need to use the parameters button and add in the ProductID parameter. For the value of this parameter you need to select the productid field from your recordset.