Okay I have 3 tables
Employee Table-(Emp IDprimarykey, LName FName)
CategoryTable-(CategoryID-primarykey, CategoryName)
WeeklyStatTable-(StatID-primarykey, EmpID-sameas EmpIDfrom Emp Table, CategoryID-Same as CatID from Category table, StatDateEntered,#PreviousReport,#Received,#Resolved,#ONhand, OldestClaimONhand-date, #SecondaryClaims
I have 15 employees, and they are responsible for entering this information into their weekly status sheets. They each have up to 5different categories that they need to account for each week. I am trying to create a form that will pull up blank, enter the empId and it fills in their Name, then enter the CatID number and it fills in the category name. It is pretty much a data entry form that they will need to fill out each week.