In our Contact records in NetSuite, you can go to the Relationships subtab and attach multiple companies, or customers, to one Contact, because we have one Contact associated with multiple Companies, shown in the picture. Attach Company
However, on our Sales Order form, we have a custom Contact field and I would like to populate the field with the Contact based on which Customer the Invoice is for. To do this, I wanted to source the field from the list of attached companies, which will then populate the correct Contact's name.
Is it possible to do this with any sort of customization? Currently, we have been making a duplicate contact for each customer they are associated with, but we are trying to avoid that. Any help would be appreciated, thank you.