Error 3022 1

[Garridon]

I have a basic Personnel database with four tables. tblPersonnel is related one-to-many to tblActions (right outer join; this is similar to the Assets and Maintenance tables in the AssetTracking database in Access). tblOrganization is related one-to-many to tblPersonnel. The last one is an archive table, identical to tblPersonnel.

When I try to add a new record, it tells me that I can't go the specified record. When I close the record, it tells me that it can't save it because of duplicated values in an index, primary key, or relationship. I have checked the fields to make sure that they allow a duplicate value. I also checked the primary keys and the relationships.

What else am I missing?



Linda Adams
Garridon@aol.com

http://www.geocities.com/hallona_2000

I'm a professional writer, published internationally.

 

[DougP]

I suspect that your index is either corupted or you are adding a record without an Index.
Make sure that the record actually has an Indexed field and it is not the same as some other record in the table.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[Garridon]

Since all the records do have an index (and it did work before this), then the index must be corrupted.

Thanks!

Linda Adams
Garridon@aol.com

http://www.geocities.com/hallona_2000

I'm a professional writer, published internationally.