Records with versions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

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.
 

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

Back
Top