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! 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
