I am new to Grocery CRUD, and i can't figure out one thing:
I have 3 tables "Person", "Houses", "Streets".
So a Person is connected to a House and House is connected to a Street.
Person:
id
name
house_id
Houses:
id
house_nr
street_id
Streets:
id
name
region_id
$this->grocery_crud->set_table('Person');
$this->grocery_crud->set_relation('house_id','Houses','{street_id} ({house_nr})');
When adding a person how can i display Streets.name instead of Houses.street_id?
I am really desperate :/ Thanx in advance!