[harshalone]

Hi I have two tables

 

Table 1===================

#Events

 

eventid

eventname

category_id

 

 

#Event_categories

ecatid

cat_name

 

 

When I render Events table I want to see category name I know I can use setrelation but my category field has 2 different name in two different tables

 

and its not possible at the moment in current format

 

$crud->setRelation('officeCode', 'offices', 'city');

 

I want to connect Events->category_id = Event_category->ecatid

 

Can you please tell me how can I connect them so that I can see category name when I edite events.

[ajuser]

Did you get a solution? I have a similar problem