[eluser]abmcr[/eluser]
[quote author="gusa" date="1212716173"]
however, my intuition says that there's another solution.
let's say that i have two controllers: sales and lines_of_sale.
i want to access lines_of_sale from the first controller, by:
1) putting a link in sales' overview table to the second controller (the url could be lines_of_sale/<sa_id>, where <sa_id> is the primary key of SALES),
2) lines_of_sale must restrict the search somehow ($this->table_access_restriction?),
3) once in lines_of_sale, the add and edit forms should remember the original call.
if that's possible, then i can save a lot of work.
the question is how can i hack codex to allow me to do that

[/quote]
Hello gusa: i have the same problem and i have made as you suggest.... but not all work. IN few words, in the overview mode, i create a link to the second table (in your case lines_of_sale) with
Code:
$config = array(
'db_table' => 'example',
'form_setup' => $this->spyc->YAMLLOAD($this->codexadmin->getDefinitionFileName('example_form')),
'controller_name' => 'Example',
'primary_key' => 'my_id',
'display_fields'=>array('textbox_test','checkbox_test','related2'),
'order_by' => 'textbox_test',
'order_type' => 'DESC',
'table_access_restriction'=>array('my_id '=>$this->uri->segment(3)),
'rules'=>$rules
);
$this->setConfig($config);
At this point i see the related data..... it is necessary, at this point, to hack the code for remembre the ur segment, when, after an edit, i go back to the overview mode, and (this is very important) for insert the uri if an new record is added...
I want to edit the codex_crumbs.php view for insert in thsi view the uri->segment, but i have not try (no time this days :-( )