Search results

Hi, thanks for your quick response.. I dont think that will get me any closer to what i want to achieve. For example, the records in the image below exist SOR. I want the database to restrict a record with PhaseID=64001 and SOR_ID=10A200 being added to DETAIL as there is no such record in SOR.

I am trying to enforce referential integrity on tables where a compound key is implemented. I want to enforce integrity on the DETAIL table so that it can only use an SOR_ID from the SOR table that has a corresponding PhaseID in the HEADER table. Here is my current diagram: The only...