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