Hi, Thanks for the response, but I'm not entirely sure what your suggesting.
An author has many books, and so I can amend the author model to point author.id at book.authorid. Conversely, many books have the same author, so I want the book model to allow book.authorid to reference author.id. However, as has been pointed out, the model on book wants to use the primary key for book which would be book.id and not book.authorid. There are a number of other fields I need to apply this too as well. Looking through the cakePHP cookbook, there's section on models and linking models together. At the bottom of the section on hasMany (User hasMany Comment), it says "One thing to remember is that you'll need a complimentary Comment belongsTo User association in order to get the date in both directions." However, it doesn't give any suggestion on what this needs to look like, and that's what I'm trying to set up. I've not tried this, but do I need to give both keys the same name or something like that? N. On Sunday, July 29, 2012 9:58:00 PM UTC+1, MaJerle.Eu wrote: > > it always search for primary key, set $primaryKey variable in model to > your column > -- > Lep pozdrav, Tilen Majerle > http://majerle.eu > > > > 2012/7/29 newt_e <snip> > >> Hi, >> >> I've have two tables: >> authors, has a column called id (amongst others) >> books, has columns called id and authorid (amongst others) >> >> Obviously a book has an author, so any value of authorid must exist in >> the authors table. >> >> When I retrieve an authors row, I also want to return the corresponding >> authors row (books.authorid = authors.id). >> >> However, when trying to update my Book model, it always seems to link >> from the id column - how do I make it work against a different column? >> >> Cheers, >> N. >> >> -- >> Our newest site for the community: CakePHP Video Tutorials >> http://tv.cakephp.org >> Check out the new CakePHP Questions site http://ask.cakephp.org and help >> others with their CakePHP related questions. >> >> >> To unsubscribe from this group, send email to >> [email protected] For more options, visit this group >> at http://groups.google.com/group/cake-php >> > > -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
