LOCAL lcdesign DO CASE CASE thisform.combo1.displayvalue='=' lcdesign="modacad.key3=thisform.text1.value" CASE thisform.combo1.displayvalue='$' lcdesign="modacad.key3$thisform.text1.value" ENDCASE SELECT * ; FROM ("U:\Data\modacad.dbf") ; WHERE &lcdesign ; order BY mainkey ; INTO CURSOR crssearchText1 being the design number field. I have now added another field named Text2 which is the type. Basically the same design number can be added into the table several times based on the Type. Therefore how can I include the second field in my search so that if something is entered in this field it will search on the type AS WELL as the design number. If nothing is entered in the second field it will exclude this from the search.