Hello Kmr,

You'd benefit from some general wording, others are better than I at citing
sources for this.

But here's a framework .

A table of staff, with "one-to-one" type info on each staff member. Add
an autonumber primary key field named "StaffID"

A table of drills, with all of the "one to one" data for drills, and then
add an integer field "StaffID".

Then link "StaffID" to "StaffID"

There are tricks to use so that you don't have to reenter data. I think
there's a wizard for this.

Sincerely,

Fred


"kmr" wrote:

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.