autonumber from table 1 not coming across in number field in table 2

m33r4

Registered User.
Local time
Today, 20:32
Joined
May 5, 2013
Messages
11
I have created 2 tables:

  1. StaffID
  2. StaffTrainingID

  • Table 1 (StaffID) - contains all personal details in the form of forename + surname + position + email + contact numbers ect. Each field/person has an autonumber.
  • Table 2 (StaffTrainingID) - contains all mandatory training/lectures (18 fields in total). I don't wish to list each staff member again in table 2 so have put a StaffID field in (data type is number).
  • However, when I try to type in the StaffID number in that field so I can link that person to the relevant training he/she has taken, Access won't allow it - where am I going wrong please:confused:
 
Could you upload a sample of your db? I dont see any reason not to work creating a relationship.
 
Could you upload a sample of your db? I dont see any reason not to work creating a relationship.

There is a 3rd table but my concern is with tables 1 and 2 at the moment.

Many thanks.
 

Attachments

  • db example.jpg
    db example.jpg
    14.2 KB · Views: 132
You should never type in the PK.

End users should not even know of their existence.

If Table One is the Main Form and Table two the sub then these numbers should be automatic.
 
Your pic is unclear but u will have to insert data using a form and a subform. Use the wizard and it will make all the commections necesary for this to work.
 

Users who are viewing this thread

Back
Top Bottom