I want to create a couple relational tables.

[burlak]

This should be an easy task but I can't seem to figure it out. I'm new to databases. I have a master table of many many songs. This table includes song title, album, product type, product ID, URL, etc. I need to create a table that will be populated with album names (for starters) and give you the listing of tracks under that album. How do I go about doing this?

 

[jackd]

Do a little research on Normalization.

Here's a link: http://www.rogersaccesslibrary.com/forum/topic238.html

First few topics here will get you orientated.