Invalid Descriptor Index when joining two fields

[cheerfulskeptic]

I have a Pervasive SQL table linked to a MSSQL 2000 table, both fields are char(7). I'm getting an Invalid Descriptor Index error in Crystal (7 and 8), what coudl the problem be? I'm not using any stored procedures or antyhing.
Thanks!

 

[cheerfulskeptic]

OK, I figured it out, when you join the two tables
tblAccounts (SQL2K) with Invoice Detail (Pervasive) everything is fine, and you can get totals, etc grouping on tblAccounts.accountid. However, when you introduce a new table, tblTerritory (for account sales territory) and link that to the territoryid field on accounts, and then group by territory, I get the descriptor error. Why is it that when i group by anything else after tblaccounts I get the descriptor error?
thanks