Thanks, That worked..... I have one more question, is there a way I can tell it what field to put in the select, right now it is using the field "name" and I would like it to use the field "common_name" since as you can figure out common name is what we call it, as apposed to the government assigned name.
Travis On Jul 3, 10:13 pm, "Paul" <s...@webprogression.co.nz> wrote: > Sorry last post sent in error > > So you have your view with some fields in it, including your forign key - > here assuming farm_id > > views/fields/add.ctp > > <?php echo $form->create('Field')?> > <?php echo $form->input('name')?> > <?php echo $form->input('another')?> > <?php echo $form->input('yet_another')?> > <?php echo $form->input('farm_id')?> > <?php echo $form->end('Submit')?> > > And in your controller action add ( as long as you have your association set > up correctly which we'll assume you do as you mention it) > > controllers/fields_controller.php > > function add(){ > ~~~~~ > $this->set('farms', $this->Field->Farm->find('list')); > > } > > This will set values to your view that the form helper will automatically > pick up and set as the values of your Field.farm_id input - which will > become a select. > > > > -----Original Message----- > From: cake-php@googlegroups.com [mailto:cake-...@googlegroups.com] On Behalf > > Of Travis > Sent: Saturday, 4 July 2009 3:34 a.m. > To: CakePHP > Subject: Forms with multiple tables > > I am new to cakePHP and am in the process of learning to use it. > > I am wondering how I can have a form element populated with elements > from a different table than the model, for example > > I am wanting to write a farm manager using cakePHP as the framework, > if I have fields that belong to farms, when you create a new field I > want to be able to select from a list of farms, and have it link > (insert farm's id as a foreign key), I have currently setup my > belongsto relationship so I can view but I cannot add. > > my original thought was to create a $options array and just loop > through the table, but I cannot do that if I do not have access to the > farms table. > > Help! > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 4214 (20090703) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > __________ Information from ESET NOD32 Antivirus, version of virus signature > database 4215 (20090704) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---