On Fri, Dec 12, 2008 at 3:49 PM, Sanfly <[email protected]> wrote: > > Okay then, lets say I change the member_years to member_payments, and > just have the member_id and payment_id fields (remove the year field). > > So long as I manage to link up these fields, I should be able to > extrapolate the "Year" data from the payment data anyway > > Even so, I cant figure out how to link the three tables. Help!
I am not sure you need to go to HABTM for your app. Are you saying that there is more than one member per payment, instead of just members have many payments? The year field is in payment anyway. Why not just set Payment belongs_to Member and Member has_many payments? Ed > > > > On Dec 13, 10:11 am, "Marcelo Andrade" <[email protected]> wrote: >> On Fri, Dec 12, 2008 at 4:13 PM, Sanfly <[email protected]> wrote: >> >> > I have three tables im trying to connect: >> >> > 1. members (primary key is 'id') >> > 2. payments (primary Key is 'id') >> >> > and then because each year that the person is a member, and they need >> > to pay their membership fees, I've got another table >> >> > 3. member_years, the fields are: member_id, payment_id, year >> >> > What sort of model associations do I need to link all these together >> > when necessary? I've been trying things out for a couple of days now >> > with no success :( Any help would be appreciated >> >> Not sure if I understood your problem. >> >> Shouldn't your join table at item 3 be >> named to "member_payment" according to >> Cake conventions? If not, maybe you >> must consider use another model for this >> information about the years. But like >> I said, I'm not sure... >> >> Best regards, >> >> -- >> MARCELO DE F. ANDRADE (aka "eleKtron") >> Belem, PA, Amazonia, Brazil >> Linux User #221105 >> >> [...@pará ~]# linkshttp://pa.slackwarebrasil.org/ >> >> For Libby's backstory be told on >> Losthttp://www.petitiononline.com/libby423/petition.html > > > > -- Ed Howland http://greenprogrammer.blogspot.com http://twitter.com/ed_howland --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
