Update parent table

  • Thread starter Thread starter Fabrice
  • Start date Start date
F

Fabrice

Hi with you all,

I've got Parent and child table with done status.
I search a query witch update the Parent table with done status if all the fields of the child table have got the done status.
I thinck it's possible but I'm hot able to find. I prefer to make it by a query than VBA.

Thanks by advance for any help.
 
You can get a count of the children and compare that against the number of
children that have the status of 'done'. If those numbers match, then
update the parent. You can do this with one query, but it may be easier to
use 2 or 3.
 
Hi with you all, hi and thank you Steve,
Yes I often forget in query when it's difficult (for me), I must try to divide it !
With your help and your indication :
You can do this with one query
Click to expand...
I'm more trustful to reach it. I'll try it.
Thanks a lot again.
Thanks to have read until there.
 
Back
Top