Relationship between Companies and Contacts Tables...
On the table ?Contacts? there is a field called ?Title?
If one of the contacts ?Title? field contains ?Chief Compliance Officer? I want that contacts field ?Contact Full Name? to be put in the field ?Chief Compliance Officer? in the ?Companies? Table.
Would really appreciate any help.