you do not really need to designate the foreign key column as a foriegn key in the data base, this will force referential integrity and cause the error you are having.
The forign key designation can be left off at the database level, but you can still use the column as a foriegn key column.