Posted by Rico on 12/28/06 19:57

Hello,

I have a foreign key constraint between two tables (Appointments and
MissedAppointmentReasons) and I'd like to allow null values in Appointments
table for the field containing the MissedAppointmentReason, but currently, I
get a Foreign Key Constraint Error when I try to add a record to the
Appointments table.

Any ideas how I can have the null values but still maintain the Foreign Key
Constraint?

Thanks!
Rick

• Next in forum: Re: SS 2005 Express- Allowing null values and Foriegn Key Constraints
• Prev in forum: Re: Replacement for my LIKE Clause
• Thread view: SS 2005 Express- Allowing null values and Foriegn Key Constraints

[Reply to this message]