New to access

I have tons of music and I want to put it into a database for easy comparison...to see if I have cetain songs etc.....How should I best go about doing this? I tried creating a table with 2 fields...one with artist name and other song title....problem was when I created a form it took every artist name as a seperate entry....another words if I had John Blah....Song 1, John Blah....Song 2, John Blah.....Song 3 ect. My drop down would have 3 John Blahs on my form and would only pull up one song....instead of 1 john blah which would pull up ALL HIS SONGS! Help....

.

.

The Matrix got you.....follow the white rabbit Neo Knock....knock.....knock

If you have access 97 there is a "Music Collection" in the database wizard. If you don't have it then send me your e-mail address and I will send you a blank copy.







Regards,