The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resources application. HR clerks use the Employees form to query, update, and in

The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. You are developing a Human Resources application. HR clerks use the Employees form to query, update, and insert employee records. They occasionally attempt to add an employee who is in a new department that has not yet been entered into the database. When this happens, they receive an error indicating that the parent record cannot be found, so they cannot commit the employee record. The HR clerks have requested that you place a button on the form to enable them to invoke the Departments form to enter the new department and save it independently. Then they want to be able to return to the Employees form and decide whether or not to save the new employee record. How should you code the When-Button-Pressed trigger to achieve this?