Table structure

Thanks for your replies. I found the following information soon after I posted which seemed to describe my situation exactly: https://support.microsoft.com/en-us/office/video-create-one-to-one-relationships-a5868c76-50ea-44b7-892d-43f2af2802e0. I have set up a one-to-one relationship between the Persons and Employees table and added the additional details needed in the Employees table.

Thanks again for your assistance.