how to update many-to-one

G

Guest

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

key violation 2
UPDATE QUERY 2
multiple one to many 2
Help! Need to update linked SQL table in Acc07 3
Many-To-One Append Query 2
One-to-Many join act as a One-to-One join 2
Update Query and Format issues 2
One-to-many query 4

Top