I have created 2 tables:
- StaffID
- 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