[Racing Chocobo]

Hi, I'm trying to find out how to do this join relation using grocery crud

I've three tables, 'inventory', 'item', 'item_name'

(below is the database schema)

[attachment=705:db.PNG]

 

What I'm trying to implement is when I want to add a record or browse all of the record in the inventory, I can get the "name" of the item from item_name table

 

So when I'm adding new record of the inventory, the field item of this can become dropdown list and the list option is the name of the item, not the item.id

 

If I use the set_relation(item, item, id), I can only get the id of the item instead of the name of the item

I donno how to make another set_relation to the third table (ItemName) using grocery_crud.

 

Any solution about this question?

 

Thank you very much^^

[web-johnny]

This is actually the relation_n_n :)  You can find all the details here: http://www.grocerycrud.com/documentation/options_functions/set_relation_n_n