Hey all,

I needed to link my contacts to accounts during initial import, so I added a "related" field type for Account. This all works perfectly except I can't export any contacts. I also cannot use the "quicksearch" for contacts either.

When tracing the SQL error, it looks like the query is trying to find an id (in the contact_cstm table) to match up to the account id in the accounts table. However, no such field exists in the contact_cstm table. I tried creating one, but can't find a way to specify that it's supposed to hold the account_id of the linked account.

The specific line that's generating the error is:

LEFT JOIN accounts relJoin1 ON contacts_cstm. = relJoin1.id

How do I resolve this? I have several thousand contacts now that would be problematic if I just removed the account related field that's linking the 2 records.

Thanks in advance,

Justin