Writing concurrent records to the same file
I have a table called tblDesignatedEmployee as follows:
DesignatedEmployeeID PK
StoreID FK
EmployeeID FK
EmployeeTypeID FK (Employee Type)
(The Employee Types are:
District Manager
Area Support Manager
Store Manager
Assistant Store Manager
None)
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.
DesignatedEmployee.mdb
DesignatedEmployeeID PK
StoreID FK
EmployeeID FK
EmployeeTypeID FK (Employee Type)
(The Employee Types are:
District Manager
Area Support Manager
Store Manager
Assistant Store Manager
None)
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.
DesignatedEmployee.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
capricorn,
I know this is a lot to ask and I don't mind breaking this question into smaller segements if I knew how?
I know this is a lot to ask and I don't mind breaking this question into smaller segements if I knew how?
ASKER
I've requested that this question be deleted for the following reason:
no response from the expert
no response from the expert
ASKER
thanks Cap - you gave me enough to think this through
ASKER
thanks cap - you made me "think" this one through. As always, I appreciate your help!
ASKER
Once a store has been selected and a district manager choosen the user wants to then add an area support manager to that store. This process is completed until all four possible support positions have been filled. My thoughts were to show in a text box in another part of the form each position by title and the person assigned to that position. This process is repeated until all four possible support individuals have been identified, and then they wanted to save the information.
This table is used as part of a process for calculating bonus. What is planned here is to select a store and it will populate in the form all the participatants that can receive a bonus, providing that the individual is Active, as designated in the tblEmployee field Active Y/N