A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables.
Now my friend carefully look at ur tables as ur doin some sort of errors while data entry as the data which u must be addin must not be present in the other table whos reference ur giving so please check out ur tables or use a combobox during form or page load event reterive the desired column from the database and ur done...
no erors no exceptions and no serious data entry errors because the data will already be present in the combobox when ur application loads
also read the
Referential Integrity[
^]in SQL for better understanding
Do rate my answer once u find it useful
Thanks & Regards
Radix :rose: