Hi, Use a trigger Juan Carlos Reyes Pacheco Oracle Certified Professional 9i,10g ( Experience in Oracle Database 7,8i too) Developer Certified Professional 6i 8 years of experience in developing, administrating database and designing -------Original Message------- From: ltiu@xxxxxxxxxxxxx Date: 01/06/05 19:02:38 To: oracle-l@xxxxxxxxxxxxx Subject: Foreign Key Constraint ... Hello, Can we have a foreign key column in tableB that points to a primary key in tableA, but the foreign key is only enforced if the foreign key value is greater than 1000? Thanks. -- Lyndon Tiu -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l