in the rsMetal recordset, you are suing the productoptions.ProductCategory column in the where clause:
WHERE optiongroups.OptionGroupName = 'Metal' AND productoptions.ProductCategory = paramItem
you need to use the productID column:
WHERE optiongroups.OptionGroupName = 'Metal' AND productoptions.ProductID = paramItem