Is there a way to generate revision levels to exisiting entries?

[Guest]

I'm trying to develop a project tracking database and was wondering if there
is a way that I can easily generate a revision level to an exisisting entry
without losing the original data etnry.
I'm very green when it comes to generating databases, but, was curious about
suggestions.

Thanks in advance.

 

[John W. Vinson]

I'm trying to develop a project tracking database and was wondering if there
is a way that I can easily generate a revision level to an exisisting entry
without losing the original data etnry.
I'm very green when it comes to generating databases, but, was curious about
suggestions.

Thanks in advance.

You will need to do this yourself, in the table design (Access knows
NOTHING about project tracking or revision levels; that's content, not
structure).

Not knowing how you want to handle the data, I can't be too sure - but
one simple solution would be to have a new field RevisionLevel in your
table. When you go to a new revision level you would *ADD* a new
record to the table (not overwrite the existing one), increment the
revision level, and copy the existing data so any needed changes can
be made. You may need to base some forms or reports on a Query
selecting the highest (most current) revision level.

Or, you may want a two table solution - the project data, related
one-to-many to a Revisions table.

John W. Vinson [MVP]