you're going to want to keep this all in one table. It's the exact same data for each 'group'
so you'd have :
Code:
tblGroup
GroupID GroupName
1 Accept
2 Supervisor
3 Reject
4 Special Test or R&D Test
5 No Test or Re-Test
tblPeople
PersonID PersonLN PersonFN ------> other people related information (this would be your employees if necessary to track who created what batch)
1 Mouse Mickey
2 Mouse Minnie
tblBatches
BatchID BatchNumber BatchDate PersonID ----> other batch related information
1 AAA-001 1/1/2013 1
2 AAA-002 1/2/2013 1
3 AAA-003 1/3/2013 2
tblResults
ResultID BatchID Grains Result ResultDate GroupID
1 1 5000 Pass 1/2/2013 1
2 1 2500 Fail 1/3/2013 2
This is just a quick guess because I don't know what your RESULTS means. It could be one test that's performed on everything you do or it could be a series of possible tests depending on the batch/item. But your tblResults would store ALL of your results and part of your data entry would be which 'group' the testing results were recorded from. Then you could summarize it however you wanted, operator (by linking to the batch table then to the employees table), group, date, etc.