I'm getting some odd results for a DataSet.Locate I am doing.

I have various grids ( both regular and Ledger ) connected to
IB_Query components.

When I click on a title they trigger a locate in the dataset.

I do an incremental search like this:

Dataset.Locate( FieldName, VarArrayOf( [ ESearch.Text ] ),
[lopPartialkey, lopCaseInsensitive ] );

This works fine except for the queries that have joins.

I get the following message when there is no match:
--------------------------------

ISC ERROR CODE:335544569



ISC ERROR MESSAGE:

Dynamic SQL Error

SQL error code = -204

Ambiguous field name between table CUSTOMER and table TERMS

TERMSNUM
------------------------------

Here is the SQL:

SELECT C.CUSTNUM
, C.CNAME
, C.ADDRESS1
, C.ADDRESS2
, C.CITY
, C.STATE
, C.ZIP
, C.ZIPPLUS
, C.CONTACT
, C.PHONE
, C.FAX
, C.EMAIL
, C.BILLTONUM
, C.TERMSNUM
, C.CUSTNOTE
, C.ESTB_DATE
, B.BNAME
, T.DESCRIPTION as TERMS_DESC
FROM CUSTOMER C
JOIN BILLTO B ON C.BILLTONUM = B.BILLTONUM
JOIN TERMS T ON C.TERMSNUM = T.TERMSNUM
ORDER BY C.CNAME

There are so many properties, I'm not sure what other information to
give, but does someone have an idea?

Rick