Database shape?
Hi

I'm in the middle of writing a database program for someone's CD collection.

The database should be able to store the title of the CD, the artist, and the names of all the tracks on the CD (even if I don't know the number of tracks on each individual CD.

I'm not sure how to design the table structure for this database (its just a simple Jet 3.51 DB and I'm using only the references to access the data i.e. not using the DAO control).

I'm not allowed to set all the records to have say 100 tracks as default because that would obviously inflate the DB massively. Does anyone know how i can achieve this with this kind of DB. I can use SQL statements as normal in Jet 3.51, but the actual SQL Server application is not available, nor are ODBC databases.

So I need someone to explain the shape of the DB to me since I cant really visualise it at the moment.

Thanks.