return latest rev + 1...

N

Nyl

Hi,

Im trying to create a database for document control
puproses. the idea is for the database to automatically
assign a document number to any new document entered in
the database and set its revision level to A and when a
newer revison is entered for the same document it will
become revision level B, then C and so forth without
replacing the record of the previous rev level.

Right now i have the following tables below. The form I
am working on is similar to that of the Order & Order
Entry Subform of Northwind database, which is DOC & DOC
Subform. My question then is how do i 'program' so that
when a new record is created, Rev A will be assigned
automatically and appear in the subform and when a new
revision is added RevNo + 1 will be returned? thanks for
reading this posting and any suggestion will be surely
appreciated.

DOCUMENTS
PK: DocNo (autonumber)
DocName (text)

REVISION
PK: RevNo (autonumber)
RevCode (text: A - Z)

DOCDETAILS
PK: DocNo (from DOCUMENTS TABLE)
PK: RevNo (From REVISION TABLE)
Date (autonumber)
Author (text)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link table query 0
assigning all employee with first name start with D rev N document 7
setfocus error 3
Related records depend on other related records 2
Embedded Excel into Word with Tables 0
Page numbering with Merged Document and IF statements 1
Assign next value automatically 2
Code for comparison of two fields between forms 7

Top