Select the option to disable a foreign keyconstraint during replication if the constraint is specific to the source database and may unnecessarily prevent new data from being entered into the destination database.
To disable a foreign key constraint for replication
In your database diagram, select the table that the foreign key constraint is attached to.
Right-click the table and select Properties.
Choose the Relationships tab.
Select the relationship from the Selected relationship list.
Clear the Enable relationship for replication check box.