"Cascading updates"

[Dan-A]

Hi All,

What is the fastest/most efficient way to update related records??

Let's say i change a flag (active/closed) in my "Purchase Order Header" table

and i want to update the same flag in the "PO Lines" table for the speceifc PO being viewed.

(Header & Lines are related on POnumber)

Thanks

--Dan

[Slobey]

Couldn't you just have a PO_flag field in the "PO Lines" table that is a calc based on your POnumber relationship. That way as soon as you change it in the "Purchase Order Header" table it is automatically updated.

[Dan-A]

Thanks, I knew i was going the LONG WAY for no reason!!!

I'll try your idea.

Dan