The database EMPLOYEES table has a foreign key constraint referencing the DEPARTMENTS table. A Human Resource application is being developed. 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 a button be placed on the form to enable them to invoke the Departments form to enter the new department and save it independently. They want to be able to return to the Employees form and decide whether or not to save the new employee record. How should the When-Button-Pressed trigger be coded to achieve this?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Tom is developing a Human Resources form for HR clerks to insert, update, and delete records from the EMPLO...
- An Application was created based on the Employees Personal Information and the Department in which they wor...
- Write the missing code for the Foreign Key constraint definition. Missing code is represented by **********...
- You have a database that contains several FOREIGN KEY and CHECK constraints. Users are having problems with...
- Which of the following constraints should you use to ensure that the combination of values in the JOB and T...
- You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables...
- Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES: --------------------- EMPLOYEE_...
- Which of the following is defined on the dependent table to implement a referential constraint?