>If I have a table that has 5 fields that if combined create a "primary key", is it faster to use LOCATE to find a record, or SEEK.
>
>The 5 fields are not all characters fields (one is date and one is numeric).
>
>Regards
Mark,
SEEK will be faster. See my reply to Walter Meester. However, I have to question your choice for primary keys. A single, integer field will be the fastest. A PK should be system generated and not rely on anything the user enters. For a more complete discussion of Primary Keys and Rushmore, see the KB articles on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer