relationship JOIN TYPE dialog window

[cedtech23]

I have created two table in my database listed below

tblEmployee
EmployeeID{Primary Key, Auto Number}
FirstName
LastName
PositionTitle

tblWorkHistory
EmployeeID {Foreign Primary Key}
Organization {Primary Key}
Position
StartDate
EndDate

I am creating a one to many relationship with the tblEmployee EmployeeID and tblWorkHistory EmployeeID
because one Employee can have many past jobs

where I run in a cloud is that in access under the edit relationship dialog window it has an button called JOIN TYPE when I click on that button it open the Join Properties dialog window and presents me with three options

1. Only include rows where the joined fields from both tables are equal

2. Include all recoreds from the 'tblEmployee' and only those records from 'tblWorkHistory' where the joined fields are equal

3. Include all records from 'tblWorkHistory' and only those records from 'tblEmployee' where the joined fields are equal

Can someone explain what access is trying to ask me as it pertains to my example. I am new to access to a basic answer would help me with future relationship issues and a better understand of the concept


Thanks

 

[Rich]

Select the second option you have what I assume is a One to many relationship between Employee and Work history