If I undestood wll your need, it should be enough to define 'username' as displayField for the user model:
model user var $displayField = 'username'; User hasMany Note User hasMany Followup On 24 Set, 16:44, jwerd <[EMAIL PROTECTED]> wrote: > I'm using 1.2.x (latest SVN from trunk) fyi. > > Anyways I've set up a notes system to keep track of my notes > internally, which is scaling to be quite efficient for what I need / > what. Now here is my dilema. I have three tables: > > notes > id > title > body > created > user_id > > users > id > username > password > > followups > id > comment > user_id > note_id > created > > I believe I'm following the Cake style table layout and structure > because most of my relations work. The followups table is supposed to > like comments on the note. > > Anyways when I'm viewing a note that has follow ups it appears below > the note's properties and says Related Followups and it's a list of > all the connected followups to that note. Now the thing is here is > what it looks like (from scaffolding) > > |Comment| ----------------------------------- | User | Note | Action > | > |This is doable, don't worry | 1 | 1 | View, > Edit, Delete | > > The problem is, I can't seem to change that 1 to the actual username > and I'm not sure how without writing a custom sql query to handle the > entire fetching of the followups to notes relationship. > > Can someone please help me out? Here's my cake relationship layout > > model user > User hasMany Note > User hasMany Followup > > model followup > Followup belongsTo Note > Followup belongsTo User > > model note > Note belongsTo User > Note hasMany Followup > > I'm not asking for someone to completely write my script just to lend > a helping hand as to if it's doable with the cake relations or do I > have to custom query this certain thign I want. > > thanks for your time appreciate any response i get. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---