I have a dbgrid connected to a datasource which points at a table. I am trying to implement an edit field in which as you type the first few letters of a name will move the current table pointer to a record which begins with those letters, while still keeping the entire table in the dbgrid. The only way I have done this so far is to use sql which only displays the results and not the entire table, can someone help?
Also I wish to sort the information in my DBgrid by a Lastname field, and not the key field, how is this done?
Thanks in advance,