I have a paradox 7 table, CustomerDetails and I have a form with 2 radio buttons, FirstName & Surname, an Edit box and a dbgrid.

Now i want the user to select what to search for ( Firstname or Surname )
and enter a string in the edit box. The this should filter the dbgrid component to only display records which match

Should I use locate, lookup or SQL? I am new to database programming and would appreciate any advise you guys have.

PS I am using C++ Builder 6