I have 3 tables
EAAS Employees contains the following PhoneID (which is unique number), unit where they work ADJ1, ADJ2….ADJ12, workstation ID’s, tag numbers for the monitor and the PC.
Employee list contains. 93 UserID(is unique), PhoneID, first and last name and skill level.
Vacation Schedule which contains the UserID and column for every working day Monday through Friday from 10/05/04, 10/06/04, 10/07/04, 10/08/04…. 4/15/04.
We move people from one unit to another depending on the work that is needed. All I do to move a person is put there name and UserID in the corresponding PhoneID in the Employee list table and then I can run a report listing the new seating assignments.
I have established a 1 to 1 from EAAS Employees PhoneID table to Employee list PhoneID table and this table is linked to Vacation Schedule using the UserID on both tables 1 to 1 relationship.
I want to be able to use a form to update the vacation schedule by units, pull up each unit in a form listing the employees in that unit and putting in the hours they are charging for each day they are scheduling off. I have created a query using the unit code from the EAAS Employees table, FirstName, LastName and UserID from Employee List and the UserID and the dates from the vacation Table. This part seems to work fine, (to me at least) When I try to use this in a form however, I am not able to enter any data in the dates field. Not quite sure what I did wrong or if I am missing anything. Any help would be greatly appreciated.
I hope that this is enough information, if not I will try to provide whatever I can to help.
John
EAAS Employees contains the following PhoneID (which is unique number), unit where they work ADJ1, ADJ2….ADJ12, workstation ID’s, tag numbers for the monitor and the PC.
Employee list contains. 93 UserID(is unique), PhoneID, first and last name and skill level.
Vacation Schedule which contains the UserID and column for every working day Monday through Friday from 10/05/04, 10/06/04, 10/07/04, 10/08/04…. 4/15/04.
We move people from one unit to another depending on the work that is needed. All I do to move a person is put there name and UserID in the corresponding PhoneID in the Employee list table and then I can run a report listing the new seating assignments.
I have established a 1 to 1 from EAAS Employees PhoneID table to Employee list PhoneID table and this table is linked to Vacation Schedule using the UserID on both tables 1 to 1 relationship.
I want to be able to use a form to update the vacation schedule by units, pull up each unit in a form listing the employees in that unit and putting in the hours they are charging for each day they are scheduling off. I have created a query using the unit code from the EAAS Employees table, FirstName, LastName and UserID from Employee List and the UserID and the dates from the vacation Table. This part seems to work fine, (to me at least) When I try to use this in a form however, I am not able to enter any data in the dates field. Not quite sure what I did wrong or if I am missing anything. Any help would be greatly appreciated.
I hope that this is enough information, if not I will try to provide whatever I can to help.
John
