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