Get a life stevie. When two people have similar trivial answers, that is NOT
plagarism.

John... Visio MVP

"Steve" wrote in message
...
It's a compliment that you plagarized my response !!!!

Steve



"Fred" wrote in message
...
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.