I have two tables
Employee Name & Shifts: Has a list of all my employees and what shifts they work.
Overtime Responses: Has the Record ID with autonumber, the date that they were asked to work overtime and what each of their responses were.
ID (autonumber)
Date Requested: Date
Employee Contacted: (tied to Employee Name & Shifts)
Responses: Yes/No
My form is tied to Overtime Responses:
There are 3 fields
Date Requested
Employee Contacted
Response
Here is the problem. Since we call multiple employees,
I want to set the employee contacted field up so you can select multiple employees at a time.
So lets say on 12/8/08, I call 5 employees and they all said no.
In my form I want to be able to enter in the date, Select all 5 employees that I called and what the response was.
In my table I want these to show up as 5 separate records.
So basically my table would like this:
ID Date Employee Contacted Response
1 12/8/08 Employee 1 No
2 12/8/08 Employee 2 No
3 12/8/08 Employee 3 No
4 12/8/08 Employee 4 No
5 12/8/08 Employee 5 No
On my form the Employees Contacted Field is set up for mulitple selections (extended) The form allows me to choose multiple selections, but when I go to the next record it doesn't save in my table correctly.
It shows the Date, but The Employees Contacted Field is blank and then it shows the response all in one record.
Help
Employee Name & Shifts: Has a list of all my employees and what shifts they work.
Overtime Responses: Has the Record ID with autonumber, the date that they were asked to work overtime and what each of their responses were.
ID (autonumber)
Date Requested: Date
Employee Contacted: (tied to Employee Name & Shifts)
Responses: Yes/No
My form is tied to Overtime Responses:
There are 3 fields
Date Requested
Employee Contacted
Response
Here is the problem. Since we call multiple employees,
I want to set the employee contacted field up so you can select multiple employees at a time.
So lets say on 12/8/08, I call 5 employees and they all said no.
In my form I want to be able to enter in the date, Select all 5 employees that I called and what the response was.
In my table I want these to show up as 5 separate records.
So basically my table would like this:
ID Date Employee Contacted Response
1 12/8/08 Employee 1 No
2 12/8/08 Employee 2 No
3 12/8/08 Employee 3 No
4 12/8/08 Employee 4 No
5 12/8/08 Employee 5 No
On my form the Employees Contacted Field is set up for mulitple selections (extended) The form allows me to choose multiple selections, but when I go to the next record it doesn't save in my table correctly.
It shows the Date, but The Employees Contacted Field is blank and then it shows the response all in one record.
Help