Revision Control Template

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

Guest

I am new to using Access.....I would like to find a simple template I can use
to track Revisions made to CAD drawings. I want to be able to use a pre
existing template.
Thanks in advance
 
You need two tables:
TblDrawing
DrawingID
DrawingTitle
DrawingNum
<<Other Fields On The Drawing You Want to include>>

TblRevision
RevisionId
DrawingID
RevisionNum
RevisionDate
RevisionDesc
RevisionBy
<<Other Fields About The Revision You Want To include>>

Create a form/subform. Main form based on TblDrawing and subformBased on
TblRevision.

Note: Show the original drawing as Revision 0 to be consistent with these
tables.

If you need help setting this up, contact me at my email address below. I
can get you up and running in a short time for a very reasonable fee.
 
Back
Top