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.

--
                                       PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                             resource@pcdatasheet.com
                                www.pcdatasheet.com