Karan, Unless you are going to reload the page every time the select list changes you're talking about using AJAX requests to update the 2nd (child) select list.
As such you want to watch the 1st select list and whenever it changes fire an AJAX request with the value and return a new set of options for the 2nd (child) select list. Google will give you loads of related pages: http://www.google.co.uk/search?q=cakephp+ajax+select+lists HTH, Paul On Oct 11, 1:03 pm, Karan <[email protected]> wrote: > Thanks for replying, > Table Structure is (id,environment_id,name) > Environment Structure is (id,depot_id,name) > Column Structure is (id,table_id,name,domain_id,mapping_col_no) > > please ignore depot_id, domain_id and mapping_col_no as they are part > of my entire project. I need the chained drop downs only for adding/ > editing columns. > > I tried building models on my own, but it got tedious and I am sure to > miss something as I am a beginner. > > On Oct 11, 12:28 pm, crisuwork <[email protected]> wrote: > > > > > > > > > You can also build your own models in model file, using > > $this->YourModel->query("Here comes the oracle SQL")..if HABTM does not work > > > using the same table structure. Is just an idea. :) > > > On 11 Okt., 07:16, Zaky Katalan-Ezra <[email protected]> wrote: > > > > Supply tables structure. > > > Environments etc. > > > > On Tue, Oct 11, 2011 at 11:19 AM, Karan <[email protected]> wrote: > > > > Hello Guys, > > > > I am a total beginner with cakephp. > > > > I have managed to establish a proper functioning CRUD app with oracle > > > > at the backend. > > > > > I have the current structure in place, > > > > Environments has many tables > > > > tables has many columns > > > > > Tables belonging to different Environments can have the same names. > > > > When I try to to add a new column for a table, I cannot distinguish > > > > between tables with the same names and different environments. (The > > > > drop down lists all tables) > > > > > What I am hoping to establish is an add page for columns in which , > > > > there will be a drop down to select the environment first and then > > > > tables belonging to THAT environment will be listed in the second drop > > > > down box. > > > > > I tried environments has many tables, environments has many columns, > > > > tables has manu columns, but it didnt help. > > > > I know callbacks can be used, can anyone nudge me in the right > > > > direction as I am newbie. > > > > > Thanks, > > > > > -- > > > > Our newest site for the community: CakePHP Video Tutorials > > > >http://tv.cakephp.org > > > > Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp > > > > others with their CakePHP related questions. > > > > > To unsubscribe from this group, send email to > > > > [email protected] For more options, visit this group > > > > athttp://groups.google.com/group/cake-php-Hide quoted text - > > > - Show quoted text - -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
