Table and multiple choices for data

[nicks60610]

I am trying to set up a table/form where a user enters some parts data, one of which is # of bad pieces, and then they have a category of "bad" that is tied to the # of bad pieces entered, but I also wanted to see if I could set up multiples instances of # bad pieces and category so that if User A has 200 bad pieces of Product X with a category of "Bad bonding" and then 100 pieces of Product X with a category of "Bad Print" that they can do this and it all ties to the same original record ID.

Any ideas??

Thanks,

 

[acent]

Soudns like you could model this similar to an inventory system. For instace, you have a table of parts:
tblParts(partID, name, ...)

and you have a table of defective parts:
tblDefParts(defPartsID, partID, qty, reasonID, ...)

and finally you have a talbe of the reasons the goods are defective:
tblReason(reasonID, name, ...)

This allows for the same part to have multiple listings of defectiveness. The form is simple, make it a datasheet of tblDefParts.

Hope this gets you closer to the solution

"If you say you can, or you say you can't, you're right!"
-- Henry Ford

 

[nicks60610]

Thanks, I will try that and see how it works!