you will need 2 tables to accomplish this, an artist table and a recordings table. the recordings table will include a foreign key used to relate the recording to the artist:
artists:
artistID - Primary key
artistName - text
etc.
recordings:
recordingID - Primary Key
recordingArtistID - Foreign Key to artists.artistID
recordingName - Text
etc.
on the first page, create a recordset to return all artists:
SELECT * FROM artists
In the repeat region, display the artists name and linking to a recordings page using a querystring variable to pass the artists ID:
<a href="recordingsResults.php?id=<?php echo $row_recordsetName['artistID']; ?>"><?php echo $row_recordsetName['artistName']; ?></a>
on the recording results.php page, create a recordset to return all of the recordings for the selected artist by filtering the recordingArtistID on the ID querystring variable.
in the repeat region, show the recording name with a link to the recordings detail page passing the recordingID column as a querystring variable:
<a href="recordingsDetails.php?id=<?php echo $row_recordsetName['recordingID']; ?>"><?php echo $row_recordsetName['recordingName']; ?></a>
On the recordingsDetails.php, create a recordset to display the selected recording by filtering the recordingID column on the ID querystring variable that was passed.
