Trying to create a database for my many albums

[keithsaccess]

How would I take all of my albums and sort them all by the artist, song, or album. I'm really stuck and hope that you can help me. I have Access for Windows 95, Version 7.0<br>

<br>

Thank you <br>

<br>

Keith

 

[Zelandakh]

Create a table called tblArtists. This stores artists.<br>
In it put idArtist (autonumber) and strArtist (text). Primary key is idartist.<br>
<br>
Create a table called tblAlbums. This stores albums.<br>
Do similar.<br>
<br>
Create a table called tblSongs. This stores songs.<br>
In it put idAlbum which should be linked to tblAlbums.idAlbum so it can pick up tblAlbum.strAlbum and strSong. Also put iTrackNo if you feel like it.<br>
<br>
Create a table called tblArtistAlbum. This stores links for artists and albums.<br>
In it put idArtist that links to tblArtist.idArtist<br>
and idAlbum that links to tblAlbum.idAlbum<br>
<br>
Now you have your database structure. Create relationships for each like named field.<br>
<br>
To add an artist, open tblArtist and type into the artist text field.<br>
Similarly for album.<br>
Create a form from tblartistalbum to pick up the artist and the album name. Stick in a sub form from the album that uses tblSongs where the link is tblalbum.idalbum so it shows only the songs for the current album.<br>
<br>
Once you get the hang of what is going on, it does make sense. Honest.

 

[Zelandakh]

Alternatively, use the wizards as I think there is one for music...