>Hi All,
>
>Ok, I've got a link table that links two, two part primary keys, together. And sense Seek is faster than locate, I need to index on the four part key. How do you build an index on four integers?
>
>Thanks

Hi Samuel,

Concatenate the integers using BINTOC(). For example:

INDEX ON BINTOC(INTFLD1) + BINTOC(INTFLD2) + BINTOC(INTFLD3) +;
  BINTOC(INTFLD4)
* To seek
SEEK BINTOC(int1) + BINTOC(int2) + BINTOC(int3) + BINTOC(int4)

The index will be smaller, with less code. Take a look at the help file for some additional ideas.

hth,