>>I have a free table with several index tags in a cdx. I have run a dedup routine to make sure that the ID field does not contain any NULL or DUPLICATE values. Yet when I issue the command ? CANDIDATE(2), I get .F. Tag 2 is the id TAG, and that field has no NULL OR DUPLICATE values. I went in and set up that field as a candidate field and ran the same ? CANDIDATE(2) command and got the same results. I must not understand the CANDIDATE() function. Help.
>>
>
>
>Just to clarify here- you created an index on your table, specified that tag as a candidate index, verified that the tag number was what you thought it was (SET ORDER TO 2) byt browsing the table, and issued CANDIDATE(2) and it returns .F.? Does the index show as a candidate indexd in the table designer?

The tag does indeed show to be be a candidate in the table designer. Yet still get false when giving the candidate command. However, it appears that when I changed the type of tag to candidate, it changed the tag number from 2 to 8. When I issue the CANDIDATE(8) command I get .T. Thanks for the help