Newbie looking for help with a formula
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 tha...
Forum Discussion
The above method is correct - but I�d ask why do you really want your table structured that way. You are duplicating info - and CRMs often aren�t set up that way.
If you just want to display the CCO on the companies form, you can embed a report in the companies table main form - and set up the report filters to only show the CCO (or whatever key employees you want to display on the company record form)
If you just want to display the CCO on the companies form, you can embed a report in the companies table main form - and set up the report filters to only show the CCO (or whatever key employees you want to display on the company record form)