I have 3 tables Companies, Contacts and Encounters. Companies is currently related to both contacts and encounters. Each company can have many of each.
The encounters table stores information related to communicating or interacting with any said company. So if a phone call or an in-person visit was made it should be noted here.
One of the fields for encounters is contact person. This is who the rep interacted with during that encounter. I want my field to be a drop down of the names of the contacts that are only specific to that company, as recorded in the contacts table.
Do I need a relationship between encounters and contacts? If so how do I limit it to only contacts on that company? Is there a super easy way to just write a formula for this?
Thank you in advance.