i have two tables
Table1 is having partno as a primary index Parent
Table2 is having partno as a regular index Child

how can i take the qty's of the partno in the child and Sum it to
the parent,

i have more than 15,000 record in the child table and around 2,000
records in the parent.
thanks for the Help