[juliofagundes]

I have the following tables and would like to know how to do these two relations:

 

GIFT
gift_id
(...)
tag_id (rel - 1:1 -> tag: tag_id)
tag_id1 (rel - 1:1 -> tag: tag_id)

TAG
tag_id
(...)
genre (M, F)

================================================== ======

 

$ crud-> set_relation ('tag_id', 'tag', 'name', array ('genre' => 'M'));
$ crud-> display_as ('tag_id', 'Male tag');

 

 

working ok.

 

But if, (note tag_id1)
 

 

$crud->set_relation('tag_id','tag','nome', array('genero' => 'Masc'));
                $crud->display_as('tag_id','Male tag');

                $crud->set_relation('tag_id','tag','nome', array('genero' => 'Fem'));
                $crud->display_as('tag_id1','Female tag');

 

Just apears Male tag, seems it doesnt find column tag_id1.

 

 

How can I do this?

 

[juliofagundes]

nobody?

[davidoster]

You can't have multiple relations on the same field.

Why don't you do, 

 

$crud->set_relation('tag_id','tag','nome', array('M' => 'Masc', 'F' => 'Fem'));

 

and just use one field instead of two? 

[juliofagundes]

Because it is necessary to choose two tags to each gift, one male and one female. I Think two separate fields for this choice would be the ideal scenario.

 

But if im wrong, help me see other ways of doing it.

[davidoster]

Then,could you have this?

$crud->set_relation('tag_id','tag','nome', array('M' => 'Masc', 'F' => 'Fem'));

$crud->set_relation('tag_id1','tag','nome', array('M' => 'Masc', 'F' => 'Fem'));

[juliofagundes]

You clarify my mind.

 

the problem was the $crud->fields(...., 'tag_id'). now $crud->fields(...., 'tag_id', 'tag_id1');

 

$crud->fields(..., 'tag_id', 'tag_id1');

 

$crud->set_relation('tag_id','tag','nome', array('genero' => 'Masc'));
$crud->display_as('tag_id','Male tag');

$crud->set_relation('tag_id1','tag','nome', array('genero' => 'Fem'));
$crud->display_as('tag_id1','Female tag');

 

Thanks in advanced man!