Error in FK_activitietable_activitytypestable

D

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
 
L

Luther Blissett

On May 14, 3:14 am, Dave C <Da...> wrote:
> 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.
 

Top