Hi All: I'm fairly new to cakePHP. Have been intently reading the cookbook and tech blogs to try to glean as much info as I can on my own. I have hit a bit of a snag with a particular scenario I'm dealing with, though, and cannot quite wrap my head around the concept of how I might accomplish this task. I'll start by laying out the tables involved in the view I wish to render, with the necessary fields listed. Then, I'll try to explain what kind of view I'm after.
First, the tables: accounts ======= id (PK) account_protocols ============= id (PK) account_id (FK) scenario_id (FK) account_protocol_type_id (FK) account_protocol_types ================= id (PK) label account_protocol_responses ===================== id (PK) account_protocol_id (FK) response scenarios ======== id (PK) scenario_category_id (FK) scenario_categories =============== id (PK) label Okay... that's about it for the tables involved. Now to try and explain what I want to do in the view. I want to generate a layered list that looks like the following: === Scenario Category Label === (filtered by scenario_id attributed to account_id) --- Scenario Label --- (filtered by account_protocol_type) 1. Protocol -> Protocol Response 2. Protocol-> Protocol Response So, the above would essentially output something like the following: === Support Issues === --- Website Down --- 1. Phone -> Webmaster (Ph. 555-555-5555) 2. Phone -> Data Center (Ph. 666-666-6666) === Billing Issues === -- Overbilling -- 1. Email -> Sales Manager (b...@testing.com) I hope the details above are not too convoluted. In the old days, I would have simply cycled through each of the stages and used a foreach () to handle the iterations in each layer. However, I'm not sure how to achieve this in the view under the MVC framework. I've done some reading about threaded lists via the the find method. But I don't see how I might arrive at my desired result with that method. Perhaps I require a bit of a re-think on the db normalization. Any input and insight on this would be greatly appreciated. Thanks in advance! Regards, Pat Dupuis --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---