" so to avoid having to redefine the relationship " redefine ? what are you talking about ? Areas hasMany Lettings when the user deletes the letting then do not delete it from the db - just soft delete it.
You got to provide more details... greets, Marcin Domanski aka kabturek On Aug 10, 6:31 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I have two tables - Lettings and Areas - each row in Lettings needs to > associate with an Area. Simple enough - each will be assigned > manually. > > The problem is that the rows in Lettings will come and go over time, > so to avoid having to redefine the relationship I need to make a join > table that will retain the connection for next time the Row appears. > Fortunately there is a consistent agent_ref key in each Lettings row. > > I've created a Letareas table as the join table with an id, agent_ref, > and area_id - but no matter what I do, I can't seem to get the system > to work. > > I'm struggling to see how the relationships work in this model - can > anyone advise? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---