Hello,

I am kind of an Access newbie.
I would like to ask a question, although I am not sure if my demand is realistic…

I’m creating a table with document codes existing of 4 numbers and one letter. For example
è 1245A
è 1258B etc.
When the documents to which the codes refer are updated, the last letter of the document increments. è 1245A becomes 1245B.
è 1258B becomes 1258C.

In an ideal situation, only the most recent version of the document should appear in my Access table.
What I would like to have is the following: when I enter a new document code in my table (eg. 1245B), the old document code (1245A) should be overwritten or deleted.

Is this something you can manage in Access?

Thanks a lot,
Lodewijk

It is pretty much "easily" doable, however the question is DO you want it?

Your loosing info by killing the previous record.... You might consider "faking" The delete by putting in a "Delete date" or somethng.

If you are just content in deleting it, why not "Just"change the document number in the record itself? Note however that in your current situation
1234A
1234B

You are limmited to
- 9999 documents
- A-Z = 26 versions.

Regards

The Mailman