Either use plugins to show the details, see this tutorial:
http://www.webassist.com/tutorials/Display-relational-table-data-with-plug-ins
or you could accomplish this using a nested recordset:
http://www.webassist.com/tutorials/Display-nested-recordsets