I'm not really sure that a relationship is what I need. I have two tables. The first holds Employee core information. The second holds instructor information, course taught, date qualified, etc. Not all employees are instructors, so normalization rules as I understanding dictate keeping the information in two different tables. Logically I'm using employeeID in both tables and want to relate them so that when I delete a record from the core table the database removes the matching records from the instructor table.
I tried to make a relationship, assuming that if I relate primary keys from both tables aht will be all I need to do. It is giving me an error, so I guess I don't know what I'm doing. Can someone please assist me in this?
TYIA
I tried to make a relationship, assuming that if I relate primary keys from both tables aht will be all I need to do. It is giving me an error, so I guess I don't know what I'm doing. Can someone please assist me in this?
TYIA