Ifthe SalesRep table had a foreign key to another table (say, Employee) that
wasnot included in the publication, inserts or updates to SalesRep would
failto replicate unless the remote database had the foreign key reference
removed.
Ifyou use the extraction utility to create the remote databases, the foreign
keyreference is automatically excluded from the remote database, and this
problemis avoided. However,there is no constraint in the database to
preventan invalid value from being inserted into the rep_id column of the
SalesReptable, and if this happens the INSERT will fail at the consolidated
database. Toavoid this problem, you could include the Employee table (or
atleast its primary key) in the publication.
174