Check your class name in the association you have defined:
 'className' => 'Children',

Should it not be:
 'className' => 'Child',

Enjoy, John

On Tuesday, 24 June 2014 14:29:52 UTC+3, Gregory Fox wrote:
>
> Hi,
>
> I need an association where therapists have many children and visa-versa. 
>
> I have 3 tables:
>
> therapists
> children
> children_therapists
>
> You can see the association below:
>
> Therapist.php
>
>      public $hasAndBelongsToMany = array('Child' =>
>                     array(
>                                    'className' => 'Children',
>                                    'joinTable' => 'children_therapists',
>                                    'foreignKey' => 'therapist_id',
>                                    'associationForeignKey' => 'child_id',
>                                    'unique' => true,
>                                    'conditions' => '',
>                                    'fields' => '',
>                                    'order' => 'Child.last_name',
>                                    'limit' => '',
>                                    'offset' => '',
>                                    'finderQuery' => '',
>                                    'with' => ''
>                                )
>         );
>
> In the Child.php model, I tried this code:
>
>     public $useTable = 'children';
>
> but that didn't work.
>
> When I code against it, I get the following error:
>
> Missing Database Table
>
> Error: Table childrens for model Child was not found in datasource default.
>
> Any help is greatly appreciated.
>
> Thanks,
> Greg
>
>

-- 
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

--- 
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cake-php+unsubscr...@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

Reply via email to