Input validation

 Have table that contains employee keys, paired up with work type keys
 (both foreign keys) and a 3rd column that you enter a billing rate in.
 Then I have a table where employees enter their work. I need to validate
 that the employee, work type pair exists, before allowing the new record
 to be inserted.

 Any thoughts as to good way to do this?


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin