Need Help Creating Links Between Tables

[Guest]

I would like help to do the following

I have a table with staff first name, surname and other details - "Staff" table

I would like another table for entering training courses that staff have done. (staff may do more than one course.) - "Course" table. This is so I can create a form with a sub-form for the courses

I want to enter the staff members first and surname into the "Course" table, and the courses they have done

How can I link the two tables together by the names? Access will only allow me to link the tables by surname, but this is no good as serveral staff members have the same surname

Many thanks for your help

Je

 

[Van T. Dinh]

What you have is a Many-to-Many relationship (a Staff Member can attend a
number of Courses and a Course can be done by a number of Staff Members).

Generally, you need 3 Tables to represent a M-to-M relationship in the
Database Structure.

Check Access Help / your Access books on Many-to-Many relationship.

--
HTH
Van T. Dinh
MVP (Access)

I would like help to do the following:

I have a table with staff first name, surname and other details - "Staff" table.

I would like another table for entering training courses that staff have

done. (staff may do more than one course.) - "Course" table. This is so I
can create a form with a sub-form for the courses.

I want to enter the staff members first and surname into the "Course"

table, and the courses they have done.

How can I link the two tables together by the names? Access will only

allow me to link the tables by surname, but this is no good as serveral
staff members have the same surname.

 

[Guest]

Hello
The best way is to use in all tables autonumber which are unique and indexed. The links between tables are based on these autonumbers
In your staff table : 1 Firstname Surname ..
In your Course table : 1 1 ... and then 2 2 ... and then 3 1 means :
Course nr 1 done by staff nr
Course nr 2 done by staff nr
Course nr 3 done by staff nr 1 ..