I want to source the vendor contact on a custom record in a custom field , when a vendor record is selected on the custom record field

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To source the vendor contact on a custom record in a custom field when a vendor record is selected on the custom record field, you can use the sourcing and filtering option in NetSuite. Here are the steps you can follow: 1. Create a custom field on your custom record for the vendor contact. Make sure to set the type of this field to List/Record and select Contact as the record type. 2. In the Sourcing & Filtering subtab of the custom field, set the Source List to Vendor and the Source From to the custom field where you select the vendor. 3. Set the Filter Using to Vendor and the Filter Compare Type to is. Then, set the Compare To to the custom field where you select the vendor. This way, when you select a vendor in the custom field, the vendor contact field will be filtered to only show contacts related to the selected vendor. If you want to display the internal ID of the vendor, you can create another custom field and set its Default Value under "Validation & Defaulting" to

{customfieldwithlistid.id}

. This will source in the internal ID of the selected vendor. Please note that this solution assumes that you have a one-to-one relationship between vendors and contacts. If a vendor can have multiple contacts, you might need to adjust the solution accordingly. Also, remember that the sourcing and filtering options are only available for certain types of fields. If you can't see these options, you might need to change the type of your custom field.