Your table structure should be something like: students (id, name), awards_ students (student_id, award_id) awards (id, name, award_type_id), award_types (id, award_name)
Your model associations should then be: Student hasAndBelongsToMany Award, Award hasOne AwardType Set the reverse assocations if you need them. HTH, Sonic On 4/17/07, surge <[EMAIL PROTECTED]> wrote: > > > Another question about scaffolding: > > Let's say I have table "student" and two other tables: > "student_awards", and "award_types". Here's an approximate description > of each table: > > student (id, name), > student_awards (id, student_id, award_id) > award_types (id, award_name) > > The idea is that a student has many awards and each award is looked up > in award_types. > > If I understand correctly, the student model should include a hasMany > association to student_awards and student_awards should include a > belongTo association to award_types. > > OK, I'm using scaffolding for all this and when I do an edit on a > student, no controls relating to the awards are shown. Actually, I'm > not sure what should be shown in this case. > > I do see a query that selects all records from student_awards that > have the current student id, but like I said, no other controls are > shown. > > Thanks for any suggestions! > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---