Search results

Thank you all for all of the help. I'm slowly getting there. I've taken all of your advice and made some updates, I think I'm finally getting it. Here is how I have it set up now. At my company, an employee can not hold more than 1 position or be on more than 1 shift at a time. As of right now...

I'm not sure if I'm doing this right or not. I added tables for EmployeePositionHistory, EmployeeShiftHistory, and SpecializedAssignmentHistory. While trying to add relationships from tblEmployeeList to the new tables, it is showing Relationship Type as Indeterminate. Here is what I added. I...

1. It would be nice to be able to track what employee's production was as they gain new assignments and trainings, it's not critical. 2. Again, it would be nice, but not critical. I wouldn't even know where to begin to include these two things. 3-4. As of right now, employees can only have 1...

Using the lookup wizard helped me to see it a little better that way. I went back and changed it up. Does this look better?

I've uploaded what I have done so far. I did make a couple changes after reading more about normalization, specifically removing the columns in tblEmployeeList for Position, Shift, SpecializedAssignment, and SpecializedTraining, and created relationships instead. I've also included a screenshot...

Is there anything I can do to prevent that?

Hi, I am new to Access and working my way through some online courses to learn everything I can about using it. I am in the process of trying to create a database to use for my work to track monthly productivity stats and annual goals (measured quarterly). Once everything is done, my goal is to...