• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 172
  • Last Modified:

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

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.

Frank Freese
Frank Freese
  • 5
1 Solution
Rey Obrero (Capricorn1)Commented:
test this and post back your comment, click button new record to add new record
Frank FreeseAuthor Commented:
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

Frank FreeseAuthor Commented:
I know this is a lot to ask and I don't mind breaking this question into smaller segements if I knew how?

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Frank FreeseAuthor Commented:
I've requested that this question be deleted for the following reason:

no response from the expert
Frank FreeseAuthor Commented:
thanks Cap - you gave me enough to think this through
Frank FreeseAuthor Commented:
thanks cap - you made me "think" this one through. As always, I appreciate your help!

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now