The CreatorCon Call for Content is officially open! Get started here.

How to Make Vendor Contact(s) inactive after Vendor Risk Assessment is Closed?

SandyL83
Tera Guru

Hello,

I posted this question the other day but haven't been able to resolve the issue. 

 

I have the requirement to set the user record(s) on the Vendor Contact table (vm_vdr_contact) to inactive after the Vendor Risk Assessment is Closed.

Has anyone done this? Any ideas on how to achieve this?

 

To add - 

I know this is done by a business rule. I started doing this by putting an After business rule on the sn_vdr_risk_asmt_assessment table. So, after the assessment state changes to Complete. 

 

From there, I need to glide to the core_company table and get the related list vm_vdr_contact entries. I need to make the users on the vm_vdr_contact inactive at this point. 

 

Any ideas on how I can do this? 

Thanks

0 REPLIES 0