Is it possible to create fields with multiple values?

[Zeroth0]

I would like to create a database of music. An album has many values for the fields: mood, style etc.

How would I structure my tables for this situation? Is it possible to have a field with many values?

[yarbrough40]

Structure it like any other database: primary key, fields for AlbumName, SongTitle, Mood, Style, Etc....

a field with multiple values can be done but is not recommended because in large database structures you will not be able to set an efficient index on it and writing queries gets ambiguous and inefficient. for instance you could have a song with styles of Rock, Funk, and Soul. they way to do it in a single field would be to be consistant on how you separate the values like always put a colon between each ex. Rock:Funk:Soul This way when you query for it you could always use a Like '%' statement to find it as well as be able to parse out the entire string in a code behind using the colon as the delineator should you need to capture the whole field and do something with the value as a whole.

The recommended way would be to simply add an entirely new record for each like so:

Artist----------Album--------------Song-------------------Style
--------------------------------------------------------------------
Fishbone---Fishbone------Party at Ground Zero-----Ska
Fishbone---Fishbone------Party at Ground Zero-----Funk
Fishbone---Fishbone------Party at Ground Zero-----Rock

this is how databases should be structured.
enjoy!

[acoolguy]

Personally i would create the field as varchar then you can check with a sql statement whats in the field and output the result.