[johanb]

Hi

 

I'm trying to get an dropdown list via set_relation but can't get it to work.

 

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `atest` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
)

CREATE TABLE `btest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `test_to_a` int(11) DEFAULT NULL,
  `asdf` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
)

 

 

        public function btest()
        {
                $crud = new grocery_CRUD();

                $crud->set_table('text');
                $crud->set_relation('test_to_a','test','id');

                $output = $this->grocery_crud->render();
                $this->_toutput($output);
        }

 

What am I missing here?

 

Johan
 

 

 

[stepgr]

I guess you have seen the typo :

  $crud->set_table('text');

??

 

also set_relation  needs (remote key, remote table, remote field) in your case you should :

 

set_table(btest)

set_relation("id","test","atest")

 

If I'm guessing right what you want to do .

 

 

EDIT:  since I saw it myself : it's not remote key is local key is set_relation so the correct is:

set_relation(local_key, remote_table, remote_filed(s))