Hi all,

Is there anyway to specify a hasMany or belongsTo association that
doesn't use a foreign key? I have two tables:

blog_posts: id, author_id, title, text
blog_favorites: id, user_id, author_id

The idea of blog_favorites is that every user can choose a few favorite
authors, and the blog_posts can be queried based on the match between
author_id's. However, there are no foreign key available for an
association, because in both tables the author_id isn't the primary
key. It seems like I would have to build an association through a
separate author table, but that just seems like unnecessary work.

Thanks.


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups 
"Cake PHP" 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to