Relating tables so records match

[Bkper087]

I'm a beginner at access and I feel like this should be incredibly easy, but I cannot figure it out. I have a master table with employee names, address, dob, etc. that I want to somehow link to another sheet that has information regarding their schedule and days off. I have set the primary key as "auto number" for each table and tried to create a referential relationship between the two id numbers. The problem I believe I am running into is that there are more IDs in the employee table than the days off table (the days off is currently blank). Is there a way for me to tell access to auto populate a record in the days off sheet for every record in the master employee sheet? I want it to do this without me having to type the employee name twice (once in each sheet) to eliminate redundancy.

[pbaldy]

The schedule table can have it's own autonumber primary key, but it would not be the field that related to the master table. You'd have another field that would have the master table's ID field in it, which would be a called a foreign key in the schedule table. The data type of that field in the schedule table would be Number, field size Long Integer.

[June7]

Cannot set PK/FK link between two autonumber fields. Set the EmployeeID FK field in schedule table as a number type.

[ItsMe]

Y'all type too fast.....

I understand that you want to JOIN two tables so you can query the relative data.

I do not understand any of your needs beyond that.

In your table with the Schedule and days off you will need a Foreign Key in a addition to said table's Primary Key (Autonumber). This Foreign Key Field will store the value from the other table's relative Primary Key field.

If the 5th record/row in your master table has a PK field and its value is 5, you would store the Long Integer 5 in the associated table's FK field. Anywhere, within your schedules table, there is a record/row that is relative to the 5th record in your main table, the FK field's value will be 5.

Multiple records in your schedule table that has an FK field with a value of 5 will create a one to many relationship.