foreign key

Integrity constraint that requires each value in a column or set of columns to match a value in a related table's UNIQUE or PRIMARY KEY.
Trigger
before insert or update...
perform a query (for existence) on the other table to see if the value exists is one way.