you will need to edit the recordset on the details to use a joined query to join the Pcolors table.
you wont need to edit the where clause of the recordset, but you will need to edit the recordsets select statement to something like:
SELECT Product.*, Pcolors.PcolorName
INNER JOIN Pcolors
ON Product.PcolorsID = Pcolors.PcolorsID
then in your page, change the binding for the PcolorsID to use the PcolorName column from the recordset.
for more details on join queries, see the following page: