How can i make a single record if i have multiple forms?

[Lainey]

Hi I am creating a database that will tally defects that happen in a
manufacturing environment. There are many different types of defects, so I
can't fit them all in one table and am forced to use a one-to-one
relationship. The user of this database will have to enter a number for each
type of defect, so to add to my troubles, all the defects will not fit on a
single form.
How do i create only one record if a user is entering data from 3 separate
forms?
I need each defect to be related back to a certain date and shift#.

 

[James Hahn]

Based on your description, I think you need to reconsider your database
design. The 'one' record you are looking for is apparently a date and shift
#. These records will be in a 'shift' table. For each shift record in the
shift table there will be a number of defect records in the defect table
(one to many), each defect record documenting one defect detected during
that shift. The defect record will include a defect type number, which will
reference a defect description in a defect description lookup table (one to
one). You will not try to fit all possible defect types on one form - each
form will refer to a single defect incident, which will have a type number
selected from a list. The defect record will have the other information
about the defect, such as time, cause, number of units affected, etc.