Hi!
i have this tables:
Clients (id, name, addrees, group,...)
Services_Clients (id, client_id, login,passwd)
documents (id,client_id,date,path)
clients must be in a group or not, and i can not change the database structure.
1) In a login form, by user/passwd i get an client group
2) after that a get all the clients id from that group like this
$jur = $this-Client-find('all', array('conditions' = array('Client.group'=$group['Client']['group'])));
ok, now, i need to get all documents from the clients of that group, so... how can i achive that?
i need to find in my model but getting only with IDs on $jur variable
sorry about my english...