Error in FK_activitietable_activitytypestable

[Dave C]

Hi
when I try and enter any contact updates I get a conflict with the FOREIGN
KEY constraint "FK_ActivitiesTable_ActivityTypesTable".The conflict cccurred
in atabase "......", table"dbo.ActivityTypesTable",column'ActivityTypeID'
IRIS;1002 Activities Table
The statement has been terminated....

Has anyone come across this before and if so how can I resolve

Thanks
DC

 

[Luther Blissett]

Hi
when I try and enter any contact updates I get a conflict with the FOREIGN
KEY constraint "FK_ActivitiesTable_ActivityTypesTable".The conflict cccurred
in atabase "......", table"dbo.ActivityTypesTable",column'ActivityTypeID'
IRIS;1002 Activities Table
The statement has been terminated....

Has anyone come across this before and if so how can I resolve

Thanks
DC

There are two tables in the database.
ActivitiesTable and ActivityTypesTable

Here I'm going to guess.

There's a column in ActivitiesTable that specifies the type of
activity and the value in that column must be a value in the
ActivityTypesTable. Somehow you have a record in ActivitiesTable with
a type not present in ActivityTypesTable.

If you know who to query SQL data, you could try finding that record
and updating its type column to a valid value. Or add the missing type
to ActivityTypesTable.