Relationships getting the best of me

[mitchem1]

I have a Contracts table (primary key: ContractID) and an Employee table (primary key: EmployeeID). I guess this is a many-to-many relationship as an employee can work on many contracts and a contract can have multiple employees. I have created a junction table called Details where the primary key is both ContractID and EmployeeID. How do I set it up to maintain integrity so that no employee can be deleted if he or she is tied to a contract? Thanks.

 

[The_Doc_Man]

When you define the relationship between the Contract table and the junction table, you should be able to check the RI box in the relationship's dialog box. You should be able to go back and edit the relationship to check the RI box later just by right-clicking on the line representing that relationship.