j$.$ Save and close the Agents table.

$4.$ Open the Listings table in Datasheet view to help determine the type of relationship and the foreign key field. A one$-$to$-$many relationship exists between the Agents and Listings tables since an agent can list many different properties, but a property is listed by only one agent. The foreign key comes by taking the primary key field from the $1$ table and adding it in as an additional field in the $M$ table. In this case, the EmployeeNum should also be added into the Listings table. Notice that the Listings table has a field that stores the agent's name. However, it doesn't have the foreign key. To minimize redundant data, you will change the Agent field so that it will now store the agent's employee number instead of the agent's name. This requires changing the data values as well as field properties.

$5.$ Edit the data values in the Agent field in the Listings table.