>I need to learn how to create a constraint in SQL Server database that will serve the following purpose (I will demonstrate on simple example):
>
>Parent Table Structure:
>FALIAS CHAR(20)
>FENTRY CHAR(10)
>FPK I (Primary Key)
>(Expression FALIAS + FENTRY is a candidate index key)
>
>Child Table Structure (Simplified):
>FENTRY CHAR(10)
>
>When user adds a record to the Child table and the value set to the field FENTRY does not exist in the Parent table I want SQL Server to reject the entry.
>
>How do I do it?
Found something
http://www.eggheadcafe.com/videodemo/sqlserver/db3.htm :)
If it's not broken, fix it until it is.
My Blog