How can i achive the following req:

i have Account and Plan objects with mamy to many relationship and Accountplan as a Junction Object

and  Account obj with status field Active and inactive
and Plan obj with status field Active and inactive

If Account Status field is inactive then change all Account related plans status to inactive only if plan related all accounts are inActive.

.......... Could you Please help me out in this req.

Could you please give me a snopshot of code here...


Thanks in Advance....................

How can i achive the following req:

i have Account and Plan objects with mamy to many relationship and Accountplan as a Junction Object

and  Account obj with status field Active and inactive
and Plan obj with status field Active and inactive

If Account Status field is inactive then change all Account related plans status to inactive only if plan related all accounts are inActive.

.......... Could you Please help me out in this req.

Could you please give me a snopshot of code here...


Thanks in Advance....................