Hi,

I have been trying to build a database where I have Companies, Employees, Dialogs, and Addresses. There are other tables, but they are not key to this question I believe. In working with data, I realize that people may not stay with the same company, and they move to others. That said, I would like to be able to preserve the history of employees at a company. Also important is the dialog. While I have it with a person, if that person leaves, I want to be able to related it to both the person and the company in the future. I have made some progress with linking tables, but it looks messy, and I am not sure if I am doing it correctly / efficiently.

Your help is greatly appreciated as this type of complicated design has been a sticking point for me. Please let me know if I have been confusing or you need more info.

Thanks,
Dave