I have a custom field in the Vendor table, which it is important to be able to search on when looking for specific Contacts. It is therefore not the Vendor Name field, which is present in the Contact table, but another field in the related Vendor table.
Since this it is not possible to add this field to the Contacts search form, my idea is to copy the value of the custom field on the Vendor, to another custom field on the Contact - automatically on Vendor Name update, through a workflow. In this way, I will be able to search on a copy of the custom field in Vendor, but it will be in Contacts. My question is, how do I copy this value on update? I cannot see that I can do a regular Field Update, because it does not allow update in related tables - or what? Or is there another way? Suggestions?