As an old xbase (Clipper) programmer recently converted to VFP5 I am still using the SEEK command and indexes to find records belonging to a particular client (for example) to display in a grid on screen. I know now that by creating a query via Select SQL I can also do this as well.

Question - is this the way to do it - by Select SQL I mean . Is it quicker on larger databases/reduce network traffic.

Any general comments would be appreciated!