DashboardNovice
Member
In the attached spreadsheet suppose:
1. First the user had Subcontractor = Unisys and Employee = Kim Adams
2. Then the user selected Hughes_Aircraft and forgot to select an employee associated with Hughes Aircraft. The problem here is that now there is an improper pairing between Subcontractor and Employee, since Kim Adams does not work at Hughes Aircraft.
3. So to prevent this, when the user selects a new Subcontractor, I would like the Employee field to automatically show a blank as if to erase what was previously there. Then when they click the Employee cell, they can select an employee from Hughes Aircraft. Is this possible?
1. First the user had Subcontractor = Unisys and Employee = Kim Adams
2. Then the user selected Hughes_Aircraft and forgot to select an employee associated with Hughes Aircraft. The problem here is that now there is an improper pairing between Subcontractor and Employee, since Kim Adams does not work at Hughes Aircraft.
3. So to prevent this, when the user selects a new Subcontractor, I would like the Employee field to automatically show a blank as if to erase what was previously there. Then when they click the Employee cell, they can select an employee from Hughes Aircraft. Is this possible?