Records with versions

D

deb

I have been asked to setup a database with documents that are entered as
originals and when they are altered they are incremented as versions.

Does anyone have an idea of the best way to set this up?

So when data for document1 (record1) is entered and is changed the original
is not changed. The new document1 is a new version... maybe document1.1.

I cant figure where to start.
 
P

pietlinden

I have been asked to setup a database with documents that are entered as
originals and when they are altered they are incremented as versions.

Does anyone have an idea of the best way to set this up?

So when data for document1 (record1) is entered and is changed the original
is not changed. The new document1 is a new version... maybe document1.1.

I cant figure where to start.
Click to expand...

if you split DocumentName and Version into separate fields, you should
be able to get a Maximum of Version for the given document using
DMAX. then just add 1 to it.
 
Top