Multiple Vendors for a vendor contact

[Poorva Bhawsar]

Hi Community,

We want to add multiple vendors for a vendor contact. If we make that vendor field as of type list on vendor contact, then its creating issues on vendor portal, its not showing any vendors, assessments and other fields on the vendor portal. Because on vendor risk engagement, we have vendor field which is of type reference, so its not allowing us to add that engagement contact or vendor contact who have multiple vendors.

And i am getting one more issue in reverting these changes, i am not able to change vendor field type as reference again on vendor contact table. Its showing me error for Type Change Not Allowed from List to Reference.

Whenever we create a new vendor, it creates a user record in sys_user table for that. So, this list type change is reflecting in user table also and showing company field of type list and here also i cant change its field type, its showing same error.

Any help would be appreciated.

Thanks in advance

[mev]

Hey Poorva, did you find a good solution for this?

[anand-bhosle]

@Poorva Bhawsar 

I’m not certain this is directly achievable as described (happy to be corrected). Can you associate multiple vendor contacts with a single vendor? Not sure its possible on vm_vdr_contact table or at the engagement level. Each contact should be unique and tied to a specific vendor.

Could you clarify your requirement — are you saying you want a single vendor contact linked to multiple vendors?

Have you considered using the Fourth-Nth Party functionality to establish those types of cross-vendor relationships?