Update 1 table with second table values

[shaddow]

I have 2 tables
table1
id-auto
amount-number
rest-number

table2
id-auto
id_table1-number
qty-number

First table it's related with second table 1 to many.
I add an record to table 2 and what i want it's to automaticaly if it's posible to update the rest from the first table

I'm using Access Forms to add a record, and i want to make a querry that updates the value in the first table.

sum(qty) group by id_table1 should go to rest in table1.

Couldnt find an elegant solution other then codding the update.



________
George, M

 

[jrbarnett]

Hi,

Unless there is a good reason for storing the total, this is not good practise. Just store table2, and use DSum/DCount functions or Group By on reports.
That is because it is all to easy to get the two out of sync, and as a result you have to ask "which is correct?"

This removal of calculated values is part of the process known as normalisation in database speak.

John

 

[shaddow]

Yes, i'm using that solution now, but i was thinking if it could be done this way.
Maybe i was thinking to much on this ideea

________
George, M