Add Line to Form Submission

[kagoodwin13]

I am making a production tracking database. One feature requested by the customer is to add a breakout for scrap reasons, so it can later be summarized into a Pareto analysis. Each shift may have multiple reasons for scrap. For example, 5 parts may be scrapped due to machine error, 4 parts may be scrapped due to bad component parts, 1 may be scrapped due to operator error (dropped and broke it).

I have attached a picture of the concept that I want to develop.

If I wanted to continuously add qty and reason codes, would I do it in this manner? Would I insert a table instead to input data into tblQualityReport (via an append query)? Can I implement a combo-box field into the input table?



Thanks for any help.

[alcapps]

I could see this done in a datasheet view style...

looks like excel..

columns
date default is now
user to use main form user selection
ID,user,date is hidden columns
ID is auto number field

ID, Qty, Reason, Note, date, user

then you could enter as many as you wanted.. on the main form you could hold the shift and person entering the data..

what you would see is

main form..
Select Shift ..if needed
Select User combo box

sub form datasheet view with table above as default

select as add new so it will always be blank ready for new records

have a button that allow it to show all records...

just thoughts.

Hope this helps