>>>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
>>
>>Yup, changing the type of tag basically recreates the tag. The tag number is the order that the tag was created.
>
>THANKS. One more question...When the tag is set as CANDIDATE, I get an error "Violates Key Uniqueness" when I create a new record in that table. What am I missing regarding the candidate type tags?
>
>jd
Candidate keys enforce uniqueness as do primary keys. the record you are adding contains a value that already exists in the table (remember to check deleted records as well).
Erik Moore
Clientelligence