Table Relationship Question

[siberianfox]

Hello! To start, this is the first Access project I have ever done. I am literally sitting here with a large book about Access, and tons of paperwork that will magically become a database. All in all, I don't feel completely lost, but I can't seem to grasp proper table relationships. Basically, here's an overview:

I have made two tables, one holds general Employee information for our company (name, address, etc). The second table holds Employee training information (employee X received training Y at such-and-such date).

I am trying to create a relationship between the two tables. As an example, our employees have Employee IDs. These are unique, and I would think they might make great Primary Keys (but who knows). So I have an Employee ID field in both tables. I would like to create a relationship between the two so that if I enter an ID in table 1, the same ID is created in table 2. This way, information from the training table matches a specific employee in the information table. I have tried creating a relationship between the two, but this did not produce those results. I would really appreciate it if someone could tell me how to begin doing this, or perhaps I just need a better understanding of relationships. Again, this is my first real day with Access. Thank you for your time.

 

[John Big Booty]

First up welcome to the forum.

Tables should only be used to store data, the user should not have direct access to the tables, all interaction with the tables and the data they hold should be done via a forms. In this way you have control over how the user sees and interacts with the underlying data.

Properly set up Form Sub form set will do exactly what you are looking for.

 

[siberianfox]

Thank you. Yes, I forgot to mention that these tables were being manipulated via forms, however this solution looks perfect. I'll give it a try, thank you very much.