Normalisation help please

[gareth.e]

so something like:

1 - cd
2 - vinyl
3 - both

?

thanks

:s why not just have a drop down box?

 

[Helium_Junkie]

:s why not just have a drop down box?

Because there is also information stored about the CD and Vinyl, therefore a relational table makes for less data overall. With a drop box you would also need another two fields to link to the CD/Vinyl info.