Hi, I'm new in cakePHP (and in database modeling (and in english:) too)! I have three models (entities): A, B and C. A hasAndBelongsToMany B, A hasAndBelongsToMany C and B hasAndBelongsToMany C All of this join-tables has own attributes and I have a "biggest" ABC join table with own attributes too. So I have A, B, C, A_B, A_C, B_C and A_B_C tables (and models).
I can create the table A_B_C in different ways: A_B_C (id, A_B_id, C_id), A_B_C (id, A_C_id, B_id), A_B_C (id, A_id, B_C_id) and finally A_B_C (id, A_id, B_id, C_id). When I create a HABTM relationship in the models A, B or C, there is an "associationForeignKey" key in the $hasAndBelongsToMany array type variable, but only one. The last A_B_C possibility (A_B_C (id, A_id, B_id, C_id)) has more then one "associationForeignKey", so I can't use it (really?). Then I have yet three possibilities: A_B_id and C_id, A_C_id and B_id or B_C_id and A_id. Why the either of them, not the other? Sorry about my english --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
