lcExact=SET('EXACT') SET EXACT OFF LOCATE FOR field1=trim(cField1) and field2=trim(cField2) and field3=trim(cField3); and field4=trim(cField4) and field5=trim(cField5) SET EXACT &lcExact>I have a form which is bound to a table. When the user clicks on my search button it pops up with another form allowing the user to search on 5 different fields (each field is within the table). I am after some advice as to what is the best and quickest way to search the table? The user may only search on one field, how do I handle it if the user decides to enter information in 3 of the fields to narrow the search results. My search basically needs to handle upto five fields?