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
You can do this with a reverse relationship.
On the current relationship make a summary field of the Minimum of the field [Record ID#] subject to the filter that the title equals Chief Compliance Officer. Call that field [Record ID# of Compliance Officer Contact]
Then do a new reverse relationship where 1 Contact has many Companies, but during the setup do not let QuickBase create a new field for you for the reference field on the right side of the relationship. Instead use the field [Record ID# of Compliance Officer Contact].
Then just look up any info such as the name field from the Contact record to the Company record.
On the current relationship make a summary field of the Minimum of the field [Record ID#] subject to the filter that the title equals Chief Compliance Officer. Call that field [Record ID# of Compliance Officer Contact]
Then do a new reverse relationship where 1 Contact has many Companies, but during the setup do not let QuickBase create a new field for you for the reference field on the right side of the relationship. Instead use the field [Record ID# of Compliance Officer Contact].
Then just look up any info such as the name field from the Contact record to the Company record.