One record with multiple entiries into one field of that record

[jadadad]

I have a project database with many fields with one field called drawing number. For each record, I may have a single drawing number with at least a single sheet. Or, I may have a single drawing with many sheets and each sheet having a unique dash number assigned to it. As an example... Drawing No. 1261106 -01, -02, -03, etc...(1-drawing with many sheets).

Also, each sheet may have a unique drawing revision assigned...example 1261106 -01,A, -02,(no revision), -03,B, etc...

1) The problem I'm having, ACCESS 2003 appears to be only 2-D and I need to go 3-D selectively, and I don't know how to accomplish this in ACCESS 2003.

2) Then there's output of displaying one record with the drawing No. with multiple sheets and drawing revisions of each sheet (if any).

Thanks for your help.

 

[traingamer]

Sounds like you need (at least) 3 related tables.

tblDrawing
DrawingID (e.g. 1261106)
other fields...

tblSheets
SheetId
DrawingID (foreign key)
Any other fields

tblRevisions
RevID
SheetID (foreign key)
Date, etc.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[jadadad]

A good start...thanks