If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2003 Multiple Entries
I am creating an employee database that contains employee's work history
organized by dates (i.e., 2003-2005, 1996-2003, etc). I currently have the table set up by employee for each time period (i.e., employee ID 00001 has five rows associated with his/her ID reflective of there work history by time period. I'm questioning whether this is an efficient way to have set up this table as I can not get a complete view of the work history on one screen (form, page, report). Any suggestions? Thanks! -- Nan |
#2
|
|||
|
|||
Access 2003 Multiple Entries
Why can't you?
You should be able to create a report with the source of SELECT * FROM TblEmployeeHistory WHERE UserID='00001'" That should return all the records for that employee. "Nan" wrote: I am creating an employee database that contains employee's work history organized by dates (i.e., 2003-2005, 1996-2003, etc). I currently have the table set up by employee for each time period (i.e., employee ID 00001 has five rows associated with his/her ID reflective of there work history by time period. I'm questioning whether this is an efficient way to have set up this table as I can not get a complete view of the work history on one screen (form, page, report). Any suggestions? Thanks! -- Nan |
#3
|
|||
|
|||
Access 2003 Multiple Entries
I currently have the table set up by employee for each time period
You need two tables - one for employee and another for work history in a one-to-many relationship. Each of the records on the many side would have employee ID, start date, end date, grade/position, and reason end. Use a form/subform to display employee/history. -- KARL DEWEY Build a little - Test a little "Nan" wrote: I am creating an employee database that contains employee's work history organized by dates (i.e., 2003-2005, 1996-2003, etc). I currently have the table set up by employee for each time period (i.e., employee ID 00001 has five rows associated with his/her ID reflective of there work history by time period. I'm questioning whether this is an efficient way to have set up this table as I can not get a complete view of the work history on one screen (form, page, report). Any suggestions? Thanks! -- Nan |
Thread Tools | |
Display Modes | |
|
|