Hi Martin,
You need to create a Dreamweaver recordset with a SQL Join so that you join the two tables together.
e.g.
SELECT
FROM table1 INNER JOIN table2 ON table2.idcolumn = table1.idcolumn
Then you can simply use the bindings and drag across the text value that is associated with the id for that record.
Cheers
Ian