I have a document control database that is giving me fits trying to maintain a history of the document and it's revision status, yet providing a workable screen that brings up JUST the most current revised document for editing and reporting needs. The main fields are structured in a table as autofield, docid, revision.
An example of my data is 5 records with the same docid [thisdoc] with revisions A through E with possibly the next docid [thatdoc] unique and not having a revision.
So, basically I'd like to be able to report on the above 6 records as
[thisdoc] [E]
[thatdoc] [0]
Any suggestions on table structure or reporting?
An example of my data is 5 records with the same docid [thisdoc] with revisions A through E with possibly the next docid [thatdoc] unique and not having a revision.
So, basically I'd like to be able to report on the above 6 records as
[thisdoc] [E]
[thatdoc] [0]
Any suggestions on table structure or reporting?