D Duane Hookom Mar 9, 2009 #2 You don't give us much to go on. If I want to track employee time in an Access table, my structure might look something like: tblTimeSheet =============== tshTShID autonumber primary key tshStartDateTime tshEndDateTime tshEmpID links to tblEmployees.empEmpID tshTCaID links to tblTimeCategories.tcaTCaID tshComments tblTimeCategories would contain records like "break", "working", "pretending to work", "Gabbing", "Water Cooler", ...
You don't give us much to go on. If I want to track employee time in an Access table, my structure might look something like: tblTimeSheet =============== tshTShID autonumber primary key tshStartDateTime tshEndDateTime tshEmpID links to tblEmployees.empEmpID tshTCaID links to tblTimeCategories.tcaTCaID tshComments tblTimeCategories would contain records like "break", "working", "pretending to work", "Gabbing", "Water Cooler", ...