Access 2003: Foreign Key/Link Question

[oceanmist]

I am setting up my very first db in Access and I am not sure I have the
relationship between these three tables set correctly.

The first table is "team leaders" and consists of ID, Firstname, Lastname
and Title.

The second table is "Task" and consists of TaskID, TaskTitle, TaskDetails,
CreationDate, CompletionDate, TeamLeaderID and LastName.

The third table is "Progress Reports" and consists of UpdateID, Date,
ProgressDetails and TaskID.

I have the tables linked as follows:

"Team Leaders" ID field linked to "Tasks" TeamLeaderID field
"Tasks" TaskID field linked to "Progress Reports" TaskID field.

Is this correct?

 

[Ken Sheridan]

The overall model looks OK, with Team Leaders being related on-to-many to
Tasks and Tasks being related one-to-many to Progress Reports. You have a
LastName column in Tasks as well as in Team Leaders, however, which is
redundant. You only need the TeamLeaderID foreign key referencing the
primary key of TeamLeaders.

Also I see you have a column called Date in Progress Reports. Call it
something like ReportDate as Date is the name of a built in function which
returns the current date, so could cause confusion.

Ken Sheridan
Stafford, England