If each release has not more than 5 styles, then its fine to use this
one. However, I would personally recommend 'hasAndBelongsToMany' since
it will provide flexibility to my system in case I decide to have 6 or
more 'styles' later.

this is a bit OT, but wouldn't 'genre' be a more suitable name than 'style' ?

and yes you want a HABTM association:

Release belongsTo Artist
Artist hasMany Release
Release hasAndBelongsToMany Genre
Genre hasAndBelongsToMany Release

you can then find releaes by Artist or Genre.

hth

jon


--


jon bennett
t: +44 (0) 1225 341 039 w: http://www.jben.net/
iChat (AIM): jbendotnet Skype: jon-bennett

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake 
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to