Writing concurrent records to the same file

Posted on 2011-10-06
Last Modified: 2012-05-12
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.

Question by:Frank Freese
    LVL 119

    Accepted Solution

    test this and post back your comment, click button new record to add new record

    Author Comment

    by:Frank Freese
    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


    Author Comment

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

    Author Comment

    by:Frank Freese
    I've requested that this question be deleted for the following reason:

    no response from the expert

    Author Comment

    by:Frank Freese
    thanks Cap - you gave me enough to think this through

    Author Closing Comment

    by:Frank Freese
    thanks cap - you made me "think" this one through. As always, I appreciate your help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now