TblStaff
StaffID
FirstName
MI
LastName
other staff fields

TblDrill
DrillID
DrillDescription

TblDrillPerformedByStaff
DrillPerformedByStaffID
StaffID
DrillID
DrillDate
DrillStartTime
DrillEndTime
DrillObserver
PassFail

Steve


"kmr" wrote in message
...
I used Access in the past, so I have a general idea on how to use it, but
now
I have Microsoft 2007, so it's not as familiar. I currently have an excel
document with staff names and drills they have performed. The drills
include
dates, times, an observer, and if they passed or failed. I had considered
doing something where I had a table with all my staff, and then connecting
tables for each person to list out the specifics for their drills. I
don't
know how to link the relationship with that though because the table name
was
the staff's name, so there wasn't a similar piece of data to link the two
tables. I need to be able to see how each individiual person is doing. I
also want to be able to see who has or hasn't been drilled in a specific
month.