I believe I found the problem with the full-text index creation. I assumed (stupid I know) that the field marked "ID" was unique and had a unique index. It is not and does not. DOH!!
>>when I try to create a full-text index, it says i need to create a full-text compatible index first.
>
>Can you resume the field type, the command you are trying to use and the exact error message you are getting?
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.