Good Morning Richard, I am enjoying these courses very much, I have a question (s) for you to help my understanding. I am building a training database by importing information from Excel spreadsheets. When I import employee information I have used their Computer ID as the primary key, no problems. When I import their training records, it shows many completed training items against each individual, I am having an issue with the primary key! if I use auto number this will give a different number for each individual which then does not work, the only way I think I can do this is to assigned a valve against each person and add this into my access table on a one by basis, I hope you can help? its hard to explain so hopefully you understand me? Any suggestions.

---

Reply from Richard Rost:

Anthony, since you're posting this under Access BEGINNER Level 1, I have to ask you which class you've actually finished watching. Have you finished Expert 1 and 2 yet? Those classes talk about relationships like this. Importing relational data is covered much later in Expert Level 22.