how to update many-to-one

J

John

I have two tables with a one-to-many relationship, and i need to SUM all the
records of one field that link to each 'one' side for each record on the
'one' side. I can do this with a select query, but then I keep getting errors
in an update query I built to transfer that select query into the 'one'
table. errors such as 'key violation' and 'must have at least one destination
field'. please help, thanks.
 
K

Klatuu

Did your really mean to say:
I have two tables with a one-to-many relationship, and i need to SUM all the
records of one field that link to each 'one' side for each record on the
'MANY' side.
Click to expand...

If so, put you hands in the air and back away from the computer! :)

It is never a good database design to carry calculated valued in a table. It
is better to do the calculation at the time you need it. Calculated fields
can easily become incorrect. It is also a waste of disk space and time.
 
Top