Lookup fields not populating data using table-to-table relationships

Hello all,

I am having trouble getting a table-to-table relationship to auto-populate some lookup data. The two tables that I am trying to connect are an Employee table and an Overtime Tracking table.

• The employee table contains fields for employee ID#, name, business title, department etc etc.
• The overtime tracking table contains fields for the year-to-date week, the overtime hours worked for that week, and the employee ID# for the employee who worked those hours. (This means that the same employee can appear on the table multiple times based on which week you're looking for)

I have created the relationship to connect the Employee table as the Parent table and the Overtime table as the Child table (since each employee has many overtime records, organized by YTD week #).

What I would like to do is to have the tables reference each other such that I can display business title (from the employee table) as an auto-populating field on the overtime table; and to be able to have each employee's form (on the employee table) being able to pull and display that employee's OT hours.

However, when I create the relationship, the overtime tracking table is not auto-populating the business title and department fields.

I'm trying to trouble shoot why the connection isn't working. Is there any specific settings or relation behaviors that I need to tune?

Thank you for any help you can provide.