I have a table called tblDesignatedEmployee as follows:
EmployeeTypeID FK (Employee Type)
(The Employee Types are:
Area Support Manager
Assistant Store Manager
I use this table as a bridge between tblEmployee and tblStore.
In my table tblEmployee I have assigned an employee type for each person, EmployeeTypeID (FK).
My form frmDesignatedEmployee is based upon tblDesignatedEmployee.
What the user wants is to:
Select a Store
Select an Employee Type
Select an Employee
They only want to see Employees that are associated with the employee type. For example, if they select District Manager only those employee that have the employee type of district manager shows in the combo box. To carry this example further, once a District Manager has been selected on the form they want to see who the district manager is. Here I was considering an unbound text control to display the person selected.
Here comes my problem. At this point, the record is ready to be written, however, the form is not complete. The user wants to continue with the other Employee Types, and once they’re satisfied they are all correct, and then save the information. Well by that time I have 4 records ready to be written. I would like to be able to save all four record concurrently when the user select Save.
Attached is part of my database and my feeble attempt to solve this.