"jarrett" <cooley222@excite.com> wrote:
>
> I have an index created in a table called (agency; candidate key). In
the
>program if I enter a agency which is numeric 6, Then delete. If I try to
>enter another agency with the previous number I get a unique index violation
>error. Even if I reindex and validate the database it won't go away. This
>is being stored in the DBC I assume. If I open the table the agency does
>not exist and the index does not find it. Anyone ever had this problem?