On Thu, May 24, 2012 at 1:50 AM, hill180 <hill...@gmail.com> wrote: > AccountID = AccountID on the Account and the Address for the Account, no > problems here. > > > The problem is the contacts. > > The join is Contact.Account_id = Accounts.Account (not Account_ID) > > Error: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL > Server]The multi-part identifier "Accounts.Account" could not be bound. >
Are you saying that the Accounts.Account and Accounts.AccountID are different fields and have different values? What's the actual SQL statement that is being created and causes the error? Mike. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php