On the detail page you will need to modify the recordset to use a joined query to return data from all of the tables. Once the recordset has been modified to return the text from the related tables, where the ID column is being displayed, replace it with the label column.
On the detail page, double click the Recordset. You will need to change the SELECT .... FROM portion, but leave the WHERE clause as is.
To Create a Joined QUERY, start with the select statement:
SELECT maintable.*, childTable1.*, childTable2.*, childTable3.*
This will select all columns from the 4 tables you wish to use. the From clause is the tricky part:
FROM mainTabel
INNER JOIN childTable1 ON mainTable.FKColumnForChildTable1 = childTable1.ID
INNER JOIN childTable1 ON mainTable.FKColumnForChildTable2 = childTable2.ID
INNER JOIN childTable1 ON mainTable.FKColumnForChildTable3 = childTable3.ID
To read more on joined queries, see the following page:
sql_join.asp