You would have to use a user-defined function to reference columns in other tables (which could have performance impacts).
Your table design may be wrong if you have a column value that is dependent on/constrained by a column in another table (other than a foreign key).
Can you provide DDL & sample data (and descriptions if names/concepts are not obvious) for your tables per How to post code problems?