Custom column in association

Hiya,

I'm wondering if this is possible - imagine you have these tables:

teams (id, name)

matches (id, date_started, created, modified)

matches_teams (id, match_id, team_id)

Every team can participate in many matches (e.g. on monday Detroit vs L.A., on wednesday Detroit vs Boston, on saturday Boston vs Tampa Bay)...

Can I somehow add more details to the association? I'd like to save how many goals the team scored. So for example Detroit scored 5 goals on monday and 1 goal on wednesday.

I believe the best place to store this would be the matches_teams table where you would create another column called score.

But do you make sure that this works automagically? How can you set the value of goals in forms (and somehow bind it to the model)?

Thanks a lot. :-) 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.