Inspection report

[FJM]

I want to include a new Inspection Report into an existing database which will electronically capture ininspection which are carried out in a Quality department.


Included in the Inspection report will be a filed for :-
Partnumber (this currently exists in a Table in the database as TEXT and is a Keyfield)
each Partnumber can have a number of ATTRIBUTES (typically numbering from 1 to 20 and these will individually describe various details of the partnumber)
each Attribute can have a number of INSPECTION RESULTS (typically from 1 to 20 which represents the number of samples which have been chosen to inspect)

I am interested in the easiest way of setting up the relationship between PARTNUMBER, ATTRIBUTE, INSPECION RESULTS so I can end up with a data entry form which will have 2 subforms (the ATTRIBUTES and the INSPECTION RESULTS) and then into a report which basically has the same set up
Any ideas any one ?
Thanks

[ranman256]

I see a form where you pick the part, client.
Then allow the user to enter what attributes to inspect . Then save.

[FJM]

I see a form where you pick the part, client.
Then allow the user to enter what attributes to inspect . Then save.

I need to add more than 1 result column - perhaps 13

[FJM]

I have created this report (which copies an existing hand printed form) and it comprises of a number of labels and text boxes. Some are populated via a data entry form and others are left intentionally blank to be completed later by an inspector.
In the report, the attributes are populated on an individual part number basis and all the Inspection results boxes are blank labels.
I have encountered a problem with this report and it is when a particular part number requires either more or less than the 15 attributes currently shown.
Can anyone tell me :-
a) is there a better way of creating this report and if not
b) is there a way of automatically adding or removing the attribute lines so they do or do not show when printed. I realise each attribute box can be "shrunk" but this only takes out the attribute box and not the 13 inspection result labels
Thanks for any help offered.