My table catalogs specific actions/conversations that may or may not lead to awarded projects.
The main/first column is the unique action/conversation. The next columns are 1) who is the contact (main person or persons initiating the action) and 2) what company they are with (sometimes this may be multiple companies if it’s a collaboration). Other columns include attachments, budgets, etc that are connected to that action/conversation/project.
Here is my issue: my company column is linked to the contact column via lookup (I have a separate contacts tab). If the contact changes/leaves companies, then the action becomes modified (either labeled with a new company or no company at all). I don’t want to disconnect the lookup, but we can’t have an action item with the wrong company.
There is also a company tab that we use to track specific legal documentation by company.