Kevin,

Depends on how you construct your SQL statement. What did you have in mind ? Give us an example of your SQL statement please.

If your lookuptable does not contain deleted records or the index to search on has a filter on DELETED() an INDEXSEEK(eExpression , .F. , cAlias, cTag) is probably the fastest way to determine if a record in a related table exist.

Walter,


>I have a program that processes through 1,000's of records in a table and then gathers information from other tables.
>
>If I want to find out if a record (just 1) exists on one of the other tables, should I issue a SELECT statement or use SEEK to search the table - I've always preferred the SELECT - does anyone have any input on this subject? - I have speed in mind here.
>
>Thanks in advance
>Kev