[ELJUSTICEIRO]

I need to make a relationship, but the field names are different
follow the example of my table

 

 

Table Category

id

code

nameCategory

 

Tabela Films

id

codeCategory

name

 

I need make a relationship with   codeCategory and code.

 

 

$crud->set_table('films');

$crud->set_relation('codeCategory','category','nameCategory');

 

don't work.

 

Help me please..

 

 

[Amit Shah]

is there any javascript error that comes in ... or what ? what is the the exact problem? Are you not able to get value in list or you not getting a dropdown in form.. what is the issue exactly can you specify?

[davidoster]

If I understand it correctly tell me if I am wrong,

 

films.codeCategory = category.code

 

and you want when the user selects a category.nameCategory to store the value of category.code to the database, right?

[ELJUSTICEIRO]

yes, that's exactly what I want

$ crud-> set_relation ('codeCategory', 'category', 'nameCategory');

How to put the relationship category.code

[davidoster]

Well, for this you will need to make a custom model.

Check here some sample code I have posted a while back.