Complicated Update query

P

PS

My setup:
tblComposition
PartName
Chemical
ChemAmtRatio
(has a composite primary key formed by PartName, and
Chemical)
sample data:
PKR1234 Al 40
PKR1234 Si 60
DFQ5678 Al 50
DFQ5678 Cu 50

tblProcessing
PartName(pk)
EquipmentID
OperatorID
RunDate
sample data:
PKR1234 NMR01 MCH01 12/09/02
DFQ5678 NMR05 MCH01 12/12/02

I have a query that combines the child records from
tblComposition into one record:
PKR1234 AlSi 40:60
DFQ5678 AlCu 50:50

What I would like to do to help simplify other queries
linking these and additional tables is to add a couple of
fields to tblProcessing to store the combined Chemical and
ChemAmtRatio. I have a form/subform for data entry to the
2 tables and would like to kick off a process so that
after the composition data is entered, it would first run
the combine query and then the update query.

Is this possible and can someone please explain how
(details please, I'm fairly new to this)
 
Top