FYI for anyone interested. ok, well i added the data into the joining table to test an sql query i could from the below url and it worked. Now i need to figure out how to get it to work with the add/edit/delete functions for the Package.
http://www.nabble.com/Filtering-HABTM-associations-using-columns-in-both-models-tf2699228.html#a7991028 $this->Package->query("SELECT * FROM packages as Package LEFT JOIN containers_packages as cp ON Package.id = cp.package_id LEFT JOIN containers as Container ON Container.id = cp.container_id WHERE Package.id = '".$this->data['Package']['id']."'"); --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---