Hi all,

I have the following TIB_Query. I feed the results to a TIB_Grid and want
to provide an incremental search capability. The desired result is that
when the CustomerName column is selected, the incremental search will use
Complaint.LASTNAME as the search column. Is this possible?

TIA
Marv

Select Complaint.cid
, Complaint.cpid
, (Complaint.FirstName || ' ' || Complaint.LastName) as CustomerName
, STREETNAMES.SNAME
, STREETNAMES.SNAMESORT
, STREETNAMES.SID
, Complaint.COMPLAINTTYPE
, Complaint.LASTNAME
From Complaint
Left Outer JOIN STREETNAMES on STREETNAMES.SID = Complaint.sid
Where Complaint.OpenDate > :startdate