sql server replication: Merge Conflict with Foreign Key -- sql server replication

Merge Conflict with Foreign Key

Humam
8/7/2003 2:29:21 PM

sql server replication: I have successfully established a merge replication
between tow SQL 200 servers with SP2.
One replicated tables (InvoiceDetails) have a relationship
and a foreign key with another replicated table (Invoice)

After a while I noticed that some records at the
subscriber table (Invoice Details) has a foreign key
conflict and could not be resolved.
I discovered that the some record from InvoiceDetails
table merged before the master records from Invoice table.

The question is how can I make sure that the records from
the master table merged before records from child table?

Please Help!!!

Re: Merge Conflict with Foreign Key

Klefevre NO[at]SPAM techdata.be
8/8/2003 2:53:41 PM

Hello,

You should change the way you set up your foreign key constraint between the
Invoice and InvoiceDetail table.
You should uncheck the option "Enfore relationship for replication" in the
relationship properties window.

Kurt

[quoted text, click to view]